Autofill a city and state from a zipcode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 400 addresses to enter in. I was wondering if there was a way,
in excel for me to type in a zip code and have Excel fill in the city and
state automatically.
 
You need to create a table first, then you can use a VLOOKUP formula, ample
description on how to use that formula is in help. Create the table like

zip city state


then use 2 vlookups, one for the city and one for the state


--


Regards,


Peo Sjoblom
 
The VLOOKUP formula will perform the task you wish. You will first need to
set up a table of all the possible ZipCodes/Cities/States you are interested
in.

Vaya con Dios,
Chuck, CABGx3
 
If you have a table of zipcodes, e.g., in a separate sheet (say, sheet
"Zips"):

A B C
1 Zip Code City State
2 00000 City1 ST
3 00001 City2 ST
....

You could then use, in your entry sheet:

A1: <zip code>
B1: =VLOOKUP(A1,'Zips'!A:C,2,FALSE)
C1: =VLOOKUP(A1,'Zips'!A:C,3,FALSE)
 
Hello,

You would have to buy that from USPS or one of the many vendors that
sells this information.


HTH,
JP
 
Back
Top