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
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