Help with matching lines in two excel files

Hi,

I hope someone can help me and explain how to match records in two spreadsheets. I have one spreadsheet with more than 240,000 records (rows)and need to match this to records (rows) in another spreadsheet. Both spreadsheets contain unique identifiers, which is made up of two cells together.

Please HELP!

post a zipped sample of your worksheet. needless to say, do not post all 240,000 rows, but just enough so we can visualize your problem and work on a solution.

Hi,

Thanks. I have attached a zipped file with the two files I need to compare.

I need to extract the full row details from the file "online status query" if the entries in columns B and C is present in the same combination in "c 240207".

I.e. BADE/SAC exists in "online status query" and in "C 240207", the details of row 91 thru 97 should therefore output to the new sheet. BADE/PAR exists in "online status query" but not in "C 240207", therefore no details should output.

Please HELP ME...!