Autofill a city and state from a zipcode
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.
|