ExcelBanter - auto zip code

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - auto zip code (https://www.excelbanter.com/excel-worksheet-functions/9411-auto-zip-code.html)

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!

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

-----Original Message-----
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!
.