Hi there,

I'm trying to create an index function to return values from Tab1, based on a drop down list on Tab2. The result should be returned to cell d6 on Tab3 but I'm not able to build the indirect function in a workable manner.

Tab3D6 is basically reading information on Tab2A1, and building a query to search the named range (Tab1Table1) on Tab1.

Not sure if you guys get it, but once you look at Tab3D6 you'll understand what I'm trying to do.


Any help appreciated.

indirect function.xlsx