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