Forum Discussion
Formula for comparing multiple columns
Good afternoon I'm struggling to get formulas to work for me when comparing two data sets. There are four columns to compare and wanting to find if there is a matching "set" in another range of ...
In F3:
=LET(m, BYROW($I$3:$L$7, LAMBDA(r, SUM(--(r=A3:D3)))), IF(MAX(m)=4, "MATCH", "NO MATCH"))
Adjust the range as needed. Then fill down.
The other one is complicated: one row on the left could have 3 matches with multiple rows on the right - one row with a mismatch on code, another row with a mismatch on start date...