Solved: Compare Worksheets

[parttime_guy]

How do I get results, if A2 & B2 is a perfect
match in the information listed in "Data" Sheet
even though there are duplicates like DATA!A4
OR DATA!B10

[geekgirlau]

I've attached a couple of different formula examples. One uses VLOOKUP with a filter field in the Data sheet, and the other uses SUMPRODUCT.

[parttime_guy]

Hi Geekgirl,

I have tested ur code for vlookup and sumproduct, they both work fine. U have made my work easier, thanks for all ur help.

Best regards