Combining and organizing 2 sheets with a common column

texas979

New member
Joined
Jul 17, 2013
Messages
4
Reaction score
0
Points
0
Here are the links for 2 sets of data. I could not attach them because they exceed the file limit.

please click the download button. I believe you need to be logged into your Google Account to download.

drive.google.com/folderview?id=0B19IVJ5jMd6LeXdLanNmSUgwcGs&usp=sharing (please copy and paste)

both data sets have one column in common--API.

I want to create a new sheet that will have combined data of both sheets, but only pertaining to API's that are common in both sheets. Book2 has fewer API's than Book1 does. However, not all the API's in Book2 are in Book1. I only want the API's that are common in both.

Can anyone help with this?

Thanks.
 
Top