LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL ERROR - series formula is too long BobY Excel Worksheet Functions 3 April 3rd 23 10:55 AM
Error formula too long JJT Excel Worksheet Functions 0 December 23rd 05 04:02 PM
Ignore error msgs in formula references gharden Excel Discussion (Misc queries) 4 June 17th 05 12:14 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
"formula too long" error message lbaskin Excel Discussion (Misc queries) 1 January 13th 05 03:05 AM


All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"