Forum Discussion
Solved
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)
4 Replies
You may create helper list with names of all your sheets and use it with INDIRECT to pickup your values.
- 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 TambourThat looks like
with formula in B2
=INDIRECT("'"&A2&"'!N17")(drag it down)
