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!
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!
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks