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.

Are the values found in Data Set 1 (AB-123; AB-456; CD-123; CD-963; etc.), also found in Data Set 2?

<colgroup><col><col></colgroup><tbody>
</tbody>

Data Set 1 (400 rows x 80 columns)
AB	123	456
CD	123	963	852	741	349
EF	567	891
Data Set 2 (1,100 rows)
AB	(other data)	(other data)	(other data)	123
AB	(other data)	(other data)	(other data)	456
CD	(other data)	(other data)	(other data)	123
CD	(other data)	(other data)	(other data)	852
CD	(other data)	(other data)	(other data)	741
CD	(other data)	(other data)	(other data)	349
EF	(other data)	(other data)	(other data)	567
EF	(other data)	(other data)	(other data)	891
EF	(other data)	(other data)	(other data)	123

<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>

Any help is greatly appreciated, thank you!!