Need Help - Verify 4 cells B,C,D,E if Sheet1 A match with Sheet2 A and display all match and no match
File attached. just 12 kb excel
First section is Sheet1 and second section is Sheet2. Sheet1 is Base file. Sheet2 is the testing file. I want to compare B,C,D,E values only if column A of Sheet1 and Sheet2 matches. Display the difference or all value match. Kindly reply thanks.
I have this formula with me , its not working
=IF(AND(A6=Sheet2!A:A,B6=Sheet2!B6, C6=Sheet2!C6, D6=Sheet2!D6, E6=Sheet2!E6), "Full match", "No")
| Attachment | Size |
|---|---|
| Compare.xlsx | 12.19 KB |
Here you go
=IF(AND(A2=VLOOKUP(A2,Sheet2!A:A,1,FALSE),B2=Sheet2!B2, C2=Sheet2!C2, D2=Sheet2!D2, E2=Sheet2!E2), "Full match", "No")
Try this
Try this instead:
=IF(MATCH(A2;Sheet2!A:A;0)>1;IF(AND(B2=Sheet2!B2;C2=Sheet2!C2;C3=Sheet2!D2;C4=Sheet2!E2);"Full match";"No"))