Excel - Display a value when specific name is entered

December 2016



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 :

This document entitled « Excel - Display a value when specific name is entered » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.