Thread: Matching table A with table B

Hi,
I have 2 table both have more than 10K rows.

I have to find which row in main table corresponds with row in Check table.
note the combination should match not just a column.
ex A25 n B25 (main table) matches with D2 n E2 (check table)
note the combination should match not just a column.

plz let me know if any clarification is required

Thanks


the sheet is uploaded at google doc as i was not able to upload it here
https://docs.google.com/spreadsheet/...hl=en_US#gid=0

Column G is what i was looking for

Thanks a lot
thats perfect