Forum Discussion
Deduping across multiple sheets
Hi, I am hoping someone can help me. (Details changed for privacy) We have an annual sale that I am preparing for. I have two sheets, one containing everyone who bought a Widget during the sale in ...
=BYROW(D2:D16,LAMBDA(row,XLOOKUP(row,A2:A16,A2:A16,"")))You can try this formula which returns the client name if it appears in FY22 and FY21.