I need a formula that matches numerical zip codes with their text county name. Is this possible? For example, if a zip code in column B is "30120", I need "Bartow" to automatically appear in column C.

Use a VLOOKUP Table. Read up on the function in the Excel help files.

You'll need to set up a table some place in your workbook for the data, e.g.

E F 1 30120 Bartow 2 24534 Cartow 3 76543 TartowWith a zip in B1, place this in C1 and drag it down next to your zips:

=VLOOKUP(B1, $E$1:$F$3, 2, 0)

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

I'm getting an error using that formula (#N/A). The zip codes are "stored as text", would that make a difference? I am using Excel 2007.

I got it! I had to convert all zips to numbers. Thank you very much for guiding me in the right direction. This will be a huge time saver for me!

I had to convert all zips to numbersYou may run into trouble doing it that way, because Excel will drop any leading zeros, so if your zip code is 01234, what you will end up with is 1234.

Use the Format - Special - Zip Codes

MIKE

Thanks, Mike! Over 96% of my zips are Georgia and begin with a 3, so dropping the 0 was not a factor for me. Good to know for future reference, though! This is going to save me so much time in the future!!

Ask Your Question

Weekly Poll