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(VLOOKUP(A2,$D$2:$E$25,2,FALSE)=B2,"TRUE","no match"),"no match")For older versions of Excel you can try this formula.