Forum Discussion
Excel help needed in comparing Data
Hi All I need some help with excel formula. Here is my problem statement. Any help/pointers on how to solve this is really helpful I have 2 documents - Doc1 and Doc2. Below is sample forma...
Hi Jack67
Assuming not necessary Excel 365 you can use VLOOKUP to lookup the ID in doc 1 and compare with doc 2.
If(same, "Yes", otherwise "No")
=IF(VLOOKUP($A15;$A$3:$E$4;COLUMNS($A:B);0)=VLOOKUP($A15;$A$9:$E$10;COLUMNS($A:B);0);"Yes";"No")Also, attached.