Matching and Merging Data from two+ columns

chocoana

New Member
Joined
Jan 22, 2012
Messages
2
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.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
like this?
Excel Workbook
ABCDE
1NameIncomeZipCityState
2Bill60,0005055NorwichVT
3Amy75,0003755**
Sheet1


Drag formula down, extend all ranges as required.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,863
Messages
5,574,720
Members
412,615
Latest member
John_W_Excel
Top