Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of city/zip codes. They are coded a-z & 1-9 for each different
city ony my list. Can I type the "Code Letter" and have the city and zip be
displayed in a cell?
 
If you mean you have something like:

A B C
1 Code City Zip
2 a Anytown 12345
3 b MyTown 23456
....
27 z YourTown 98765

If your "Code letter" is in D1, then one way is to use

City: =VLOOKUP(D1,A:B,2,FALSE)
Zip: =VLOOKUP(D1,A:C,3,FALSE)
 
Back
Top