Forum Discussion
Solved
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
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