Forum Discussion
Matching duplicates in two sets of columns excel version 2211 in office 365
I need to search for a matching reference number (looking for A2 in column D) and then see if the date (column E) is the same as that of the first (B2) I have tried using XLOOKUP as a nested rule...
=IFNA(IF(XLOOKUP(A2,$D$2:$D$25,$E$2:$E$25)=B2,"TRUE","no match"),"no match")With XLOOKUP you can try this formula.
=BYROW(A2:A20,LAMBDA(row,IFNA(IF(XLOOKUP(row,D2:D20,E2:E20)=OFFSET(row,0,1),"TRUE","no match"),"no match")))If you want to spill the result you can try BYROW and LAMBDA.
Thank you so much for all your input. Unfortunately I'm not getting matches or "true" on a small sample I made to test them. I will need to look at this later due to other commitments now, but didn't want to not respond after your kind help.