View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dread
 
Posts: n/a
Default 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?