PDA

View Full Version : Solved: Compare Worksheets



parttime_guy
03-22-2007, 08:38 PM
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
03-22-2007, 09:59 PM
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
03-24-2007, 06:48 PM
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
:bow: :friends: