I'm using data tables and structured references in a spreadsheet. There are many identical tables (ie identical column headings). The table names are unique.

I analyze different scenarios of a fixed number of tables (3) with several dozen complex nested IF statements, VLOOKUP and use find/replace to change the table names in the formulas.

Is there a way to write the formulas so that the names of the thee tables can be entered into three cells thus making the formulas "dynamic" and eliminating the need to use find/replace?

I am familiar with the INDIRECT function, and can write simple macros. I don't know VB.

Thanks in advance for any help.....