View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.