CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Antoine Claval
Antoine Claval

Reputation: 4944

Evaluate Sheet name indirectly

Within the strict context of vanilla google sheets, I would like to check if there is a way to dynamically address a Sheet by name.

For instance, if one of my sheets is named "foo's great", I can access it in a formula by the following: 

=COUNT('foo''s great'!A2:A500)

Now, let's say I want to stop hardcode the sheet name and want to use a cell containing that sheet name, resolve it to the sheet name, and do my things.

Something along those lines: 

=COUNT(EVALUATE_RESOLVE(Z1)!A2:A500)

Where the cell Z1 contains a String, resolving to an existing sheet name within the workbook.

Upvotes: 1

Views: 92

Answers (1)

player0
player0

Reputation: 1

formula would be:

=COUNT(INDIRECT(Z1&"!A2:A500"))

where cell Z1 contains a valid sheet name

Upvotes: 1

Related Questions