Xlookup in 2 directions issue

[axelg]

I'm using a table like this

In cell B3 and B5 I have some calculated values which I pick up in other sheets.

B3, gives the value "=Invul_LOA", celname that is filled in on onther sheet. Basically that is always a number that i lookup in "Overal length" column.
B5, gives the value "=Result_DockPilot_RigthIn", calname that is calculated on other sheet. This is were I have the issue I believe. The value here is to be looked up in "Overal length" row (A,1,2,3A,3b,4,5)


The formula I use is : =XLOOKUP(B3;B16:B57;XLOOKUP(B5;C15:I15;$C$16:$I$57);0;1)

I cannot get it to work correctly? If in B5 there is a letter, it works. if a number, it doesn't (when I ad value(b5) in the formule, the number works , but the letters don't ???


Seems it has to do with where I pick up these B5 Values. Because if I manually type ( A or number ) then it works fine.
So maybe something in the layout of where i pick up the B Values ? But how can I get that correct?

Many thansk

 

[axelg]

up is in the "if not found" argument of the 2nd xlookup, so if B5 is a number stored as text & isn't found then it will effectively do the same lookup but adding 0 to

Great, thanks, good to know.

 

[Fluff]

You're welcome & thanks for the feedback.