Automatically generating a city name based on entered zip code

  • Thread starter Thread starter Lycean
  • Start date Start date
L

Lycean

I would like to be able to input a ZIP code in column E and have it
automatically generate the appropriate city name. I have thousands of
addresses to enter, and not having to enter the city would help me out a
great deal. An example would be much more helpful than just the formula as
I'm not used to using excel in such a way. (I never use it for formulas or
anything, so I don't understand the terminology a lot of the time)

Thanks,
Lycean
 
The first step is to download a list of zip codes from the usual sources.
Say cols E & F contain:

35004 Moody
35005 Adamsville
35006 Adger
35007 Alabaster
35010 Alexander City
35014 Alpine
35016 Arab
35019 Baileyton
35020 Bessemer
35022 Bessemer
35023 Bessemer
35031 Blountsville
35033 Bremen
35034 Brent
35035 Brierfield
35040 Calera
35042 Centreville
35043 Chelsea
35044 Childersburg
35045 Clanton
35046 Clanton
35049 Cleveland
35051 Columbiana

then put the desired zip code in A1 and in B1, the formula:

=VLOOKUP(A1,E:F,2,FALSE)
 
Back
Top