Forum Discussion
mtscho
Jan 12, 2019Copper Contributor
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.
- mtschoCopper ContributorThanks 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 TambourThat looks like
with formula in B2
=INDIRECT("'"&A2&"'!N17")
(drag it down)