match horizontal data set to vertical data set

[chelson]

Hello,

I have two data sets that I need to match; one is arranged horizontally and the other is arranged vertically. I need to determine if the data points in the horizontal data set are also found in the vertical data set. The data sets are rather large - Data set 1 (horizontal) is ~400 rows by 80 columns, and Data set 2 (vertical) is ~1,100 rows. I am using Excel 2013.


[TABLE="width: 187"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Are the values found in Data Set 1 (AB-123; AB-456; CD-123; CD-963; etc.), also found in Data Set 2?[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 555"]
<colgroup><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 3"]Data Set 1 (400 rows x 80 columns)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]456[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]963[/TD]
[TD="align: right"]852[/TD]
[TD="align: right"]741[/TD]
[TD="align: right"]349[/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD="align: right"]567[/TD]
[TD="align: right"]891[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Data Set 2 (1,100 rows)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]456[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]852[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]741[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]349[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]567[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]891[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD](other data)[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




Any help is greatly appreciated, thank you!!