can I auto fill zip code column when city is typed

[Elsie C.]

I am using excel 2003 and am typing a customer list of 3,000 names. I found
once I type a name, when I begin to type it again, the program AUTO FILLS it
, which is great because it cuts down on my actual typing. Therefore, I want
to know if there is some way to set up my worksheet so once I type the CITY
name in one column the ZIP CODE column will auto fill with the correct
corresponding numbers. I tried defining a city name and making a formula to
equal the numbers, but it didn't work. I don't know if I'm doing it
correctly.

 

[Gord Dibben]

Elsie

You could use a two column lookup table and a VLOOKUP formula to insert the ZIP
CODE for the entered city.

See Debra Dalgleish's site for excellent instructions on VLOOKUP formulas and a
downloadable sample workbook to assist.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

I am using excel 2003 and am typing a customer list of 3,000 names. I found
once I type a name, when I begin to type it again, the program AUTO FILLS it
, which is great because it cuts down on my actual typing. Therefore, I want
to know if there is some way to set up my worksheet so once I type the CITY
name in one column the ZIP CODE column will auto fill with the correct
corresponding numbers. I tried defining a city name and making a formula to
equal the numbers, but it didn't work. I don't know if I'm doing it
correctly.

Gord Dibben MS Excel MVP