Comparing Two Data Sets

[jones273]

Hi all!

I am working with two different data tables. Data Set A has 2 columns and Data Set B has 4 columns. The 2 columns in Data Set A are the same information as the first 2 columns in Data Set B. I am looking for some guidance as to how create a macro that finds exact matches between A & B. More specifically, if BOTH columns of a row (A1 & B1) in Data Set A are found in Data Set B, I want a new table created with all four cells from the matching row in Data Set B.

EX.

Below is a line from both columns of Data Set A (A1 & A2) and all four columns from what would be considered a match in Data Set B.

A1 A2 B1 B2 B3 B4 767 MSY 767 MSY 1-11-2014 1-12-2014 <tbody> </tbody>

<tbody>
</tbody>

Thanks for your help and let me know if you need more information!

 

[Latchmaker]

Create a third column of Data in Data set A it will use this formula ...fill it down
=CONCATENATE(A1,B1)

Add this formula to the fifth column in Data set B.........fill it down

=IF(ISNA(VLOOKUP(CONCATENATE(A1,B1),Sheet2!C:C,1,0)),"","X")
Change the "Sheet2" to the name of Data set A

Then filter Data Set B by Column 5 for all "X"

Copy-paste-special to a new work book to create your new dataset.