Forum Discussion
Solved
Be able to reference table name listed in a cell as input for a function (copy of text in function)
Hi all! I wonder if it is possible to write down the name of a table column in a cell (for instance Table3[Time passed] in cell B3) and use that as an input in a function. This should look like t...
You could use the INDIRECT function for this:
=ADDRESS(ROW(INDIRECT(B3)),COLUMN(INDIRECT(B3)))
Warning: in Excel in Microsoft 365 and Office 2021, this returns a dynamic array with the addresses of all cells in Table3[Time Passed].
You could use the INDIRECT function for this:
=ADDRESS(ROW(INDIRECT(B3)),COLUMN(INDIRECT(B3)))
Warning: in Excel in Microsoft 365 and Office 2021, this returns a dynamic array with the addresses of all cells in Table3[Time Passed].
HansVogelaar Thank you, this was exactly what I was looking for!