XLOOKUP Error

[catherine9910]

Ok friends, what am I doing wrong? 

[#2 · Accepted solution]

I figured it out. I had the lookup value and array backward in the formula.

[#3]

@catherine9910 

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