Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Zip Code Macro | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |