How do I set up a default zip code that correspondes to a town?
 

Hi - I am currently entering data into excel for my brothers company such as
the name, address, and phone number of the customer. I am wondering if it is
possible to create a default zip code and area code for each town that I
enter. For example if I enter Huntley, IL. as the town is it possible that
the area code 630 and the zip code 60142 would automatically be entered in
the appropiate column? I am using office 3000. Thanks in advance.....

How do I set up a default zip code that correspondes to a town?
 

Wow! Even Office 3000 can't anticipate what you want to achieve!

Seriously, look up VLookup & HLookup in the help files; the columns
containing the zip & area code will be formulae. You might hold the table of
town, zip, area in a hidden sheet.

"Tarandon" wrote:

Hi - I am currently entering data into excel for my brothers company such as
the name, address, and phone number of the customer. I am wondering if it is
possible to create a default zip code and area code for each town that I
enter. For example if I enter Huntley, IL. as the town is it possible that
the area code 630 and the zip code 60142 would automatically be entered in
the appropiate column? I am using office 3000. Thanks in advance.....