Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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

Check out our Excel Resources

Re: 3 dimensional Lookup

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.