Forum Discussion

J. G.'s avatar
J. G.
Copper Contributor
Jan 25, 2018
Solved

EXCEL - Use dynamically created string as refference to table objects

Hello there, i was trying to dynamically create links in a column of an "addresstable" in a workbook. All the necessary information is stored in separate dedicated tables in the document. First, i ...
Excel Desktop
Formulas & Functions
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jan 25, 2018

    If the table string builds correctly, then you need to use the Indirect() function to turn that string into a reference. Like this

     

    =INDEX(INDIRECT([@[tablename_string]]),2)

     

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jan 25, 2018

If the table string builds correctly, then you need to use the Indirect() function to turn that string into a reference. Like this

 

=INDEX(INDIRECT([@[tablename_string]]),2)

 

  • J. G.'s avatar
    J. G.
    Copper Contributor
    Jan 25, 2018
    Thank you very much Ingeborg. I had tried indirect before, but it wouldn't work. I now discovered i really had (unsupprisingly) a syntactic error in the formula. So, thanks for pointing me into the right direction again. :) Jan