Forum Discussion
Update my formula to return "Yes" if a match is found, and if not, return the corresponding value
Hi, I'm using this formula =IFERROR(IF(MATCH(1, (Sheet1!A2=Sheet2!A:A) * (Sheet1!B2=Sheet2!B:B), 0), "Yes"), "No") to return "Yes" if a match is found, and if not, to return "No". Now, I want to upd...
How can there be a corresponding value if there is no match?
Is it possible to update the formula to return a value if one of the cell value is matching?
=XLOOKUP(Sheet1!A2&B2, Sheet2!$A$2:$A$1000&Sheet2!$B$2:$B$1000, Sheet2!$C$2:$C$1000, "No")
(I wouldn't use entire columns for performance)