auto zip code

E

esslingerdav

Good Day!
Novice excel user here. Will excel put the zip code into c1 depending on
the city and state inputted into a1 and b1? I have a rather large mailing
list to create and am looking for shortcuts in typing.

Thanks!
 
J

Jason Morin

You need to create a master list of city/state and zip
codes and then use VLOOKUP to pull in the zip code. To
keep it simple, I would merge the city/state into one
column, separated by a comma. For example, on Sheet2:

A B
1 North Andover,MA 01845
2 Methuen,MA 01844
etc.

Then in C1, use:

=VLOOKUP(A1&","&B1,Sheet2!A:B,2,0)

HTH
Jason
Atlanta, GA
 
Top