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")
=XLOOKUP(A2,Sheet2!B:B,Sheet2!A:A)
Will work also. Just drag down.
Will work also. Just drag down.
Thanks! I entered it and I got 0 back as a value. I'm trying to figure out why because there's an entry it should have picked up
As a comment, with XLOOKUP we may return entire spill at once
=XLOOKUP(A2:A10,Sheet2!B2:B100,Sheet2!A2:A100, "no such")EDIT: I figured out what I did wrong and the formula is working. Thank you!
EK_Blackwell , glad it helped
- Didn't know this! I'll actually start using this in my day-to-day work, thanks for explaining!
