Structured References: Reference Table Name from Cell

[Kadmi]

Hi everyone,

I am using structured references in my formulas and am looking for a way to change the formula references all at once instead of one by one.
For instance, I am referencing Table1[ColumnB] in the formula and would need to change all Table1[ColumnB] references to Table2[ColumnB].

Is there a convenient way of doing this? My initial idea was to try replace the table names with references to cells which contain the actual name.
So instead of

=Table1[@ColumnB]

something like

=A1&[@ColumnB] and A1 containing the string "Table1"

However, I was not able to make it work and google was not able to help either.

Thank you for your help,

Kadmi

 

[Fluff]

Hi & welcome to MrExcel.
You could use the Indirect function, although it is slow & volatile

=INDIRECT(A1&"[@ColumnB]")

 

[Kadmi]

Thank you for the great help and the welcome!

Exactly what I was looking for. Tried indirect in the past but it looks like my syntax was off

 

[Fluff]

You're welcome & thanks for the feedback.