I have a very large excel document with about 780,000 rows and I would like to compare the data in one of its columns with the data I have an another spreadsheet´s column. (i can put that data in the same worksheet). I would like to see which one of those match...

here is example

GED50106
PUD10036
GEL10009
GED10093
GED02885
ILD10012
GED00617
GEL10328
GED00617
ILD00341
GED10145
ILD00378
GED10118
GED10233
GED02702
GEDS5053
GED10271
ILD00418
GED02695
GED02616
GED02164
GED02340
GED01594
GED01071
GED50112
PUD00504
GED50424
GED02268
GED02192
I have another columm with the same kind of data... I want to see if they match, and which one they are..