formula too long error?
I'm getting an error "formula too long" for the folloiwng IF statement:
=IF(B15="",0,IF(B19="Full Splash, INDEX(Sheet 1!$A$1:$L$3, MATCH
($B$5,Sheet 1!$A$1:$A$3,), MATCH($A$13,Sheet
1!$C$1:$L$1,))*VLOOKUP(B15,Data Table!$U$10:$V$15,2,FALSE), (INDEX(Sheet
1!$A$6:$L$8, MATCH($B$5,
Sheet 1!$A$6:$A$8,),MATCH($A$13,Sheet 1!$C$6:$L$6,))*VLOOKUP(B15, Data
Table!$U$10:$V$15,2,FALSE)))
I know this doesn't exceed the Nested If limit so I don't know what the
problem is.
Can I not use INDEX/MATCH/VLOOKUP within my IF statement?
|