Forum Discussion

Sgriff2022's avatar
Sgriff2022
Copper Contributor
May 16, 2022

combine reference to workbook and cell

I'm trying to create a formula that references an external workbook location in row A to retrieve information to create a master summary reference workbook.  Using the table below as an example, I wa...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 16, 2022

Sgriff2022 

You may use INDIRECT(), but with that all referenced workbooks shall be opened.

  • Sgriff2022's avatar
    Sgriff2022
    Copper Contributor
    May 16, 2022

    Thanks for the reply Sergei. I tried that, but get a #REF! error. My formula is =INDIRECT('[B1]Sheet'!C5)
    I also tried a concat formula, but that one just displays the text.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 16, 2022

      Sgriff2022 

      That is

      =INDIRECT("'[B1]Sheet1'!C5")

      or combine the text

Resources