INDEX function - 3d range from lotus to Excel

[gazzabj]

I am trying to convert a function from Lotus to Excel, it takes th
following form.

In Lotus:

The Range OUTPUT is SHEET1:E206..SHEET55:M306
The formula to use this 3d range is
@INDEX(("<<"&$filepath&">>ORDER"),0,5,3)

This returns a value from column 5, row 0, using the 3rd reference, i
this case the 3rd sheet

I need to convert this into excel, so far I have..

OUTPUT range defined as ='SHEET1:SHEET55'!$E$206:$M$306
I am trying to use the formula
INDEX(myfile.xls!ORDER,5,0,3)

But this returns a #VALUE! error

Is it possible to use 3d ranges in this way in Excel? and can anyon
help with a solution for this?

Thanks in advance for any help.

Ga

 

[Peo Sjoblom]

You will find that Excel's 3d functions are basically none existent
You might be able to find some workarounds using Laurent Longre's excellent
add-in

http://longre.free.fr/english/