Excel

[Ring Guy]

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?

 

[Ragdyer]

What's the "Code Letter"?

 

[JE McGimpsey]

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)