Two Way Lookup With Indirect

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!

Hi, here is an example workbook.

Tables are on the first tab, and I need formulas in cells C2:F4 that will pull those expected values. I need a formula that will be able to lookup the value in B2 and C1 to the corresponding table in A2.

I thought of using an indirect in order to get the actual table name. Let me know if you have any other ideas.

Book3.xlsx

Open to any other ideas, just keep in mind that I simplified the data. There are about 10 tables all with the same columns/headers just different values on the inside.