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

"Peo Sjoblom" wrote:

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


"Drewscifer" wrote in message
...
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.