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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find cities visited 4
Drop-down list and error message 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Formatting Cells - Hex Values 3
Special converting of string date&time to date format 3
Turning off formatting 7
Zeros on the left 6
Conditional Formatting 8

Back
Top