Hi,

Let's say that I have an "official" Excel table with the number of employees per department.

Then I have many other sheets, one sheet per department actually, each containing complex formulas.

I would like to use structured references in these formulas, like this:

Employees[[#All],[DeptSales]]

What I would like to do is to replace DeptSales in my formula by the cell A1 because there is the name of the department.

I tried Employees[[#All],[indirect(A1)]] but it doesn't work.

The reason why I want to do this is that there are many departments so I would like only to change the text in the cell A1 and not need to adapt all the formulas.

Any ideas? Please?