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.