Excel - Display a value when specific name is entered

February 2017



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€",""))))

Related


Published by aakai1056. Latest update on February 15, 2013 at 02:29 PM by aquarelle.
This document, titled "Excel - Display a value when specific name is entered," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).