Dynamic cell reference for use with Index function

[Prudent]

I have several tables in a workbook, JanTable, FebTable, MarTable, April Table etc...
I wish to use a dynamic reference in a cell on another sheet to access any one of these tables
In A1 below I have the formula shown (highlighted in column B for ease of reference) and it works to return a value of 0.97
In A4 below I have the formula shown, replacing the table name of AprilTable with a cell reference that contains it (in A3), this gives the ref error.
What am I doing wrong here?

Many thanks.

 

[RoryA]

Welcome to the forum.

You'd need to use INDIRECT(A3) but note that that will make your formula volatile so it will recalculate whenever your workbook does for any reason; that may or may not be an issue depending on the complexity of your workbook, and how many such formulas you have.

 

[Prudent]

Welcome to the forum.

You'd need to use INDIRECT(A3) but note that that will make your formula volatile so it will recalculate whenever your workbook does for any reason; that may or may not be an issue depending on the complexity of your workbook, and how many such formulas you have.

Many thanks.