I have a question. If I have 3 fields: zip code, city and state; is there a way where I can have the user of my form enter their zip code and it will populate both city and state. I have the data, I just dont know exactly how to code it. Hopefully someone can help me out. Thank you in advance, Ken 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. 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. World Airport Codes provides info for almost every airport in the world, including airport codes, abbreviations, runway lengths and other airport details. 764,852 Canadian Postal Codes (6,578 Cities / Towns / Places) Database Description: This database contains 764,852 unique postal codes of Canada across 13 provinces and territories. Each postal code record consists of the city / town name, province / territory (name and abbreviation code), city type, latitude and longitude.