Forum Discussion
Solved
XLOOKUP Error
Ok friends, what am I doing wrong?
- I figured it out. I had the lookup value and array backward in the formula.
As variant
=XLOOKUP($B$17, $A$3:$A$15, OFFSET( XLOOKUP($B18, $B$1:$Y$1, $B$3:$Y$15),, COLUMN() - COLUMN($C$17)) )and drag it to the right and down