help

Question

Can someone help me with this fct :&nbsp;=IF(ISBLANK(F55));"";IF(F55='TRM DB'!G1;"'TRM DB'!G6");IF(F55='TRM DB'!H1;"'TRM DB'!H6");IF(F55='TRM DB'!I1;"'TRM DB'!I6");IF(F55='TRM DB'!J1;"'TRM DB'!J6");IF(F55='TRM DB'!K1;"'TRM DB'!K6")&nbsp;i have the Value error&nbsp;

oliverscheurich · Answer

Abdel735&nbsp;=IF(ISBLANK(F55),"",IF(F55='TRM DB'!G1,'TRM DB'!G6,IF(F55='TRM DB'!H1,'TRM DB'!H6,IF(F55='TRM DB'!I1,'TRM DB'!I6,IF(F55='TRM DB'!J1,'TRM DB'!J6,IF(F55='TRM DB'!K1,'TRM DB'!K6))))))Maybe with this formula.&nbsp;

hansvogelaar · Answer

Abdel735&nbsp;
Or
&nbsp;
=IFERROR(HLOOKUP(F55; 'TRM DB'!$G$1:$K$6; 6; FALSE)); "")

abdel735 · Answer

OliverScheurich no there is a problem with the formula 😕

oliverscheurich · Answer

Abdel735&nbsp;The corrected formula works as intended.

Forum Discussion

help

4 Replies

Resources