It depends what you're trying to do.
It looks as though you're comparing 2 columns in each table to find matches:
A formula at cell G2 (copied down) does this and that may be all you need.
However, you may have a problem; there may be more than one row in the All sheet that matches the two columns in the Data sheet. I've highlighted which rows this applies to in column N where if there's a value >1 there are multiple matches. In a few instance I've shown those matches in column O at rows 28, 34 and 512 (where there are 3 matches).
So are you looking to return only complete matches, or maybe on more than 2 columns?


Edit: I've just noticed you're using Office 2016 so some of the functions I've used may not work, although the results of those formulae should still show. Tell me if the G2 formula fails and I'll re-write.

Attached Files

msofficeforums49833Test.xlsx (197.3 KB, 5 views)