0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Display a value when specific name is entered

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

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).