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...

excel

Formulas and Functions

HansVogelaar
May 11, 2022
Maar7

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].

PeterBartholomew1

Silver Contributor

May 12, 2022

HansVogelaar

Hans, do you have a version of Excel 365 with VSTACK?

If so, the attached file, though probably overcomplicated, is interesting that it returns a Table, or a specific field, specified by name, but without using the volatile function INDIRECT.