Mapping format

A

André Hänsel

Hi,

can I set a cell format that maps values to descriptions?

So that when I enter "1" in the cell it will be shown as "Washington",
when I enter "2" it will be shown as "New York", etc.

Regards,
André
 
G

Gary''s Student

Consider using two cells:
one for the value
the other with a VLOOKUP() formula to get the text.
 
Top