Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
Error formula too long | Excel Worksheet Functions | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
"formula too long" error message | Excel Discussion (Misc queries) |