Finding duplicate data between sheets

I have two sheets - one has a set of data which is a subset of the second, unfortunately an important data item exists on the second sheet that ought to be in the first but got excluded

I need to select rows from the first sheet, having matched them in the second sheet using data fields that do exist in both sheets

Any help gratefully received!

Thanks

The construct I use for this is =ISNUMBER(MATCH())


=ISNUMBER(MATCH(Sheet1!A1, Sheet2!A:A, 0))

=ISNUMBER(MATCH(Sheet1!B1, Sheet2!B:B, 0))

=AND(ISNUMBER(MATCH(Sheet1!A1, Sheet2!A:A, 0)), ISNUMBER(MATCH(Sheet1!B1, Sheet2!B:B, 0))



You get the idea. These formulas will give you TRUE/FALSE answers.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.