Excel formula help for zip codes

February 21, 2011 at 11:55:02
Specs: Windows Vista
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.

See More: Excel formula help for zip codes

Report •

February 21, 2011 at 12:27:34
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   Tartow

With 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.

Report •

February 21, 2011 at 12:56:21
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.

Report •

February 21, 2011 at 13:36:01
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!

Report •

Related Solutions

February 21, 2011 at 15:57:25
I had to convert all zips to numbers

You 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



Report •

February 21, 2011 at 19:54:42
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!!

Report •

Ask Question