Hi,
I have a spreadsheet with a zip code column to which I want to append city and state information from a second spreadsheet that I have that contains 40,000+ rows of zip, city and state information.
So I think I that I somehow need to match the zip codes from the two sheets and then merge in the info?
Here's what it looks like:
Spreadsheet A
Name Income Zip City State
Bill 60,000 05055
Amy 75,000 03755
Spreadsheet B
Zip City State
05055 Norwich VT
03075 Hanover NH
80202 Denver CO
80209 Denver CO
I'd like to get that city and state info from spreadsheet B into spreadsheet A without compromising the data I have in A.
Thank you so much for your help! I love this community.
I have a spreadsheet with a zip code column to which I want to append city and state information from a second spreadsheet that I have that contains 40,000+ rows of zip, city and state information.
So I think I that I somehow need to match the zip codes from the two sheets and then merge in the info?
Here's what it looks like:
Spreadsheet A
Name Income Zip City State
Bill 60,000 05055
Amy 75,000 03755
Spreadsheet B
Zip City State
05055 Norwich VT
03075 Hanover NH
80202 Denver CO
80209 Denver CO
I'd like to get that city and state info from spreadsheet B into spreadsheet A without compromising the data I have in A.
Thank you so much for your help! I love this community.