Hi All, have a tricky question you all can hopefully help me with.

I have 10 different tables that are the same dimensions (5x5) that have the same headers/columns but different values. I want to create a formula that can do a 2 way lookup based on the table name (using an indirect). Where I'm having trouble is figuring out how to reference the proper column/header array since each of the tables are located in different places.


In my data,

Column A has the Table Name
Column B has the Column Lookup Value
Row 1 has the Row Lookup Value

I imagine it'd look something like this: =Index(INDIRECT(A2),MATCH(B2,COLUMN ARRAY,0),MATCH(C1,HEADER ARRAY,0))

Any ideas? Thanks!