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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.