Forum Discussion
opinionatedsagitarrian
Feb 24, 2026Copper Contributor
XLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and ha...
NikolinoDE
Feb 28, 2026Platinum Contributor
As an additional option,
=LET(
lookupValue, IF(H9<>"", H9, H7),
lookupColumn, IF(H9<>"", A2:A10606, C2:C10606),
XLOOKUP(lookupValue, lookupColumn, B2:B10606, ""))