Forum Discussion

Copper Contributor

Sep 23, 2022

MULTIPLE IF CONDTITIONS OVER 64

Greetings! I have a formula with more than 64 nested items and I need to simplify it so that I can reference a labor matrix. =IF(B2=0.1,Gas!C35,IF(B2=0.2,Gas!D35,IF(B2=0.3,Gas!E35,IF(B2=0.4,G...

excel

Formulas and Functions

PeterBartholomew1

Silver Contributor

Sep 23, 2022

msariego

Something like

= TEXTJOIN(",",, IF(lookupArray=testCell,returnArray,"") )

or

= TOROW( IF(lookupArray=testCell, returnArray, NA()), 3)

would pick out terms from the return array that correspond to a matching term in the lookup array.