Hello,
I am trying to compare values in two workbooks (weekly output from two different systems) to compare the values and give me a Match/No Match in third. The first column has the unique identifier and there are a number of fields which are compared individually and finally give me a match when all values are identical. The attached file has a manually identified field values, but I'm hoping this can be done with a formula.
Thank you in advance for your help.
in B2
=IF(VLOOKUP($A2,SheetA!$A$2:$D$1000,COLUMN(),0)=VLOOKUP($A2,SheetB!$A$2:$D$1000,COLUMN(),0),"","No ")&"Match"
copy across to column D and down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
since I worked on this, I'll post my solution but it may not be needed ...
IF(VLOOKUP($A2,SheetB!$A$2:$D$6,COLUMN(B$1),FALSE)=VLOOKUP($A2,SheetA!$A$1:$D$6,COLUMN(B$1),FALSE),"Match", "No Match")
can be dragged right and down.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
@Special-K, like that version of
see how it is used and like it better than my version - where it is appropriate of course.COLUMN()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks