Mapping format

  • Thread starter Thread starter André Hänsel
  • Start date Start date
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é
 
Consider using two cells:
one for the value
the other with a VLOOKUP() formula to get the text.
 
Back
Top