Enter a city based on a short list of zip codes

[jcgwilym]

I have a small table of zip codes and cities. I'd like a long membership list to pick up the city name based on the zip code. Is this a VLOOKUP, or is there something else more appropriate? Thanks.

[NBVC]

Depending on the order of the columns in your table you can use VLOOKUP or INDEX/MATCH.

The Index/Match will work no matter the order, so safer to use that.

e.g.

=INDEX($B$2:$B$100,MATCH(X2,$A$2:$A$100,0))

where A2:A100 contain the Zip codes and column B has the Cities, X1 contains the Zip code to look up.