How to overcome the "Formula too long" error on windows excel...

[puppykak]

I have worked on this really difficult long formula, but the problem is, I have been working from my Mac. And my office, which this formula was made for, is all PC. Now generally this isn't a problem, but apparently PC's have a limit on how long the formula can be. Is there anyway to overcome this? I really need this formula to work..

Please help!

 

[wsjackman]

where would you like it to be in the outside document

'[Outside Excel Document.xls]Sheet2'!$A$1:$B$20

maybe?


=VLOOKUP(B15,'[Outside Excel Document.xls]Sheet1'!$A$8:$I$11,'[Outside Excel Document.xls]Sheet2'!$A$1:$B$20,0)

 

[puppykak]

I believe from your example, this might work

=INDEX('[Outside Excel Document.xls]Sheet1'!B5:I7,MATCH(B15,'[Outside Excel Document.xls]Sheet1'!A5:A7,0),MATCH(B3,'[Outside Excel Document.xls]Sheet1'!B4:I4,0))

Never tried across WorkBooks, but it might work.
lenze

I was trying this formula, and I am close, but it keeps giving me the result that is in the cel just one left and one up from the result I need. What's going on?

 

[puppykak]

I figured everything out! Thank You!

 

[puppykak]

Thank You espcially wsjackman, you've been really helpful and patient with me!


..oh...and by the way...I am not a he...teehee.



If I need anymore help I will be sure to post! Thanks!