3 dimensional Lookup

Posted by AlexK on October 02, 2001 1:13 AM

The lookup and index functions work in 2 dimensions
- column and row.

How can I create a 3 Dimensional lookup that uses tab, column , & row ?

I'd like to be able to create range names that include
several sheets and lookup data by tab name as well as row & column

Thanks

Posted by AB on October 10, 2001 4:54 AM

I have an example file on my website that shows how to create a UDF to return a 3D array that can be used for 3D lookups.

Look for "consol_array_udf.zip" in the VBA section.

Regards,
AaronThe Excel Logic Page