Excel - Display a value when specific name is entered

April 2018



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€",""))))
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 (https://ccm.net/).
Excel - Automatically insert months
Excel - A Macro to display comment on mouse-over