ISERROR-formula too long-FORMULA

D

Donna

{=IF(ISERROR(INDEX('Weekly Supply Plan 081903a.xls'!
month1,SMALL(IF('Weekly Supply Plan 081903a.xls'!
skus=$D4,ROW('Weekly Supply Plan 081903a.xls'!skus)-ROW
('Weekly Supply Plan 081903a.xls'!sku1)+2,ROW('Weekly
Supply Plan 081903a.xls'!sku2)+2),2),6)),"--",INDEX
('Weekly Supply Plan 081903a.xls'!month1,SMALL(IF('Weekly
Supply Plan 081903a.xls'!skus=$D4,ROW('Weekly Supply Plan
081903a.xls'!skus)-ROW('Weekly Supply Plan 081903a.xls'!
sku1)+2,ROW('Weekly Supply Plan 081903a.xls'!sku2)
+2),2),6))}

Here's the formula - the link portion of 'Weekly Supply
Plan 081903a.xls'changes to a network link '\\Business
Operations\Allocations\....'Weekly Supply Plan
081903a.xls' and causes the formula to extend over 1024
characters. I can't even click into the formula once
it's too long to even update - a major issue. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISERROR and INDEX Funcion question 8
Editing Lookup Formula Error 6
Circumvent "Series formula is too long" 2
IF(ISERROR?? Help with hiding #NUM! 5
Macro line too long? 3
Lookup returning one more than expected 3
I keep getting formula too long message when I set up a workbook 1
Overcoming "Formula too long" 2

Top