View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default Autofill a city and state from a zipcode

Hello,

You would have to buy that from USPS or one of the many vendors that
sells this information.


HTH,
JP

On Oct 19, 11:26 am, Drewscifer
wrote:
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


--