Forum Discussion

mtscho's avatar
mtscho
Copper Contributor
Jan 12, 2019

create a list

Hi Experts, i have an Excel file with 35 identical structured spreadsheets and i need a list which contains cell a2 and n17 from each spreadsheet displayed in a list. which function do I need to use?

yr help is much appreciated

 

Michael

  • That looks like

    with formula in B2

    =INDIRECT("'"&A2&"'!N17")

    (drag it down)

  • You may create helper list with names of all your sheets and use it with INDIRECT to pickup your values.

    • mtscho's avatar
      mtscho
      Copper Contributor
      Thanks Sergei, what would then the Syntax look like, if I want the value from cell N17 for example?

      First item on the helper list is Tambour
      • That looks like

        with formula in B2

        =INDIRECT("'"&A2&"'!N17")

        (drag it down)

Resources