Forum Discussion

Maar7's avatar
Maar7
Copper Contributor
May 11, 2022
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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    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].

HansVogelaar's avatar
HansVogelaar
MVP
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's avatar
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.

=Tableλ(tableName,fieldName)

Resources