Excel - Display a value when specific name is entered

Ask a question


Issue


I want Excel to display a value when I type a specific name.
Excel - Display a value when specific name is entered
NAME VALUE  
E1  200,00 €   
E2  400,00 €   
E3  800,00 €   
E4  1 200,00 € 


For example, when I type E1 in cell A1, the value 200,00 € appears in cell B1.

Solution


In B1:
=IF(A1="E1","200.00€",IF(A1="E2","400.00€",IF(A1="E3","800.00€",IF(A1="E4","1400.00€",""))))
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team