Matching and Merging Data from two+ columns

[chocoana]

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.

 

[Robert Mika]

like this?

Excel Workbook
	A	B	C	D	E
1	Name	Income	Zip	City	State
2	Bill	60,000	5055	Norwich	VT
3	Amy	75,000	3755	*	*
Sheet1

Drag formula down, extend all ranges as required.

 

[chocoana]

Thanks so much for your help!!!