Forum Discussion

Abdel735's avatar
Abdel735
Copper Contributor
Sep 06, 2022

help

Can someone help me with this fct :   =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...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 06, 2022

Abdel735 

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

 

Abdel735's avatar
Abdel735
Copper Contributor
Sep 06, 2022
OliverScheurich no there is a problem with the formula 😕

Resources