Forum Discussion
Solved
IF THEN WHERE statement?
I have two sheets in a workbook. I need to set a cell's value where the ID on one sheet equals the ID on a different sheet. But there's not always going to be a match, they don't line up equally. Is...
As a comment, with XLOOKUP we may return entire spill at once
=XLOOKUP(A2:A10,Sheet2!B2:B100,Sheet2!A2:A100, "no such")
Thank you, everyone! The formula is working!
Anytime
I would like to ask you please to flag the post as answered.
I would like to ask you please to flag the post as answered.