Excel as a 3D spreadsheet?

[Constant]

Hi,

We all use excel mostly in a 2 dimensional way but in fact Excel is 3 dimensional with the help of the sheets.

We have Hlookup and Vlookup functions to manage data in a sheet.

My question is: do we have a kind of “Slookup” function that works in a similar way upon different sheets.

For ex; let’s have 10 sheets named sheet01 to sheet10.

We can define a two way array sheet01!A1:sheet10!A100?

And self a 3 dimensional array for ex. Sheet01!A1: sheet10!D20

Which actual functions are applicable in these cases? Or which functions can we create (Ctrl+shift+enter) to do what we are enable to do on classical 2 dimensional array??

Thanks for your attention

C. Peten

 

[NARAYANK991]

Hi ,

See if this helps :

http://www.informit.com/articles/article.aspx?p=2031329&seqNum=9

Narayan

 

[Constant]

Hi ,

See if this helps :

http://www.informit.com/articles/article.aspx?p=2031329&seqNum=9

Narayan

Thanks a lot, I will buy this book.
greatings from Bruges in Belgium.

 

[chirayu]

Do you mean a function that works as HLOOKUP + VLOOKUP = INDEX(MATCH

 

[Monty]

“Slookup”?

 

[Constant]

Yes, functions that can be use like those on the 2D arrays.
But Mr Narayan gives me an excellent site where I can find a book about this.
Thanks a lot
C. Peten

 

[Monty]

Excellent! All the best!