Autofill a city and state from a zipcode

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

 

[Peo Sjoblom]

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

 

[Guest]

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

 

[JE McGimpsey]

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)

 

[Guest]

So Excell does not contain or cannot access all US zipcodes?

 

[JP]

Hello,

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


HTH,
JP

 

[JE McGimpsey]

No. It's a spreadsheet application...

 

[aorick]

You can download a zip code database here:
http://databases.about.com/od/access/a/zipcodedatabase.htm