MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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 "" in the VBA section.

AaronThe Excel Logic Page