View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.