Forum Discussion
More than 127 conditions for an IFS
Is there anyway with IFS or perhaps another formula that I can use when I have more than 127 conditions/logical statements?
Create a table of conditions, then create a formula to evaluate the condition and wrap a VLOOKUP or INDEX+MATCH for the returned value to your table of conditions.
example:
=VLOOKUP((1+1),[AdditionTable],2,0)
cheers
2 Replies
Create a table of conditions, then create a formula to evaluate the condition and wrap a VLOOKUP or INDEX+MATCH for the returned value to your table of conditions.
example:
=VLOOKUP((1+1),[AdditionTable],2,0)
cheers
Andrea_Schutt You could nest a second IFS inside the first one:
=IFS(condition1, result1, condition2, result2, ..., TRUE, IFS(...))
But do you really need more than 127 conditions? Some kind of INDEX/MATCH, VLOOKUP or XLOOKUP formula might be better.
