CODEWITHSUNDEEP
google-sheets
user13039528
user13039528

Reputation: 3

How to use the value of a cell and insert that into a formula referencing a sheet?

I have a source sheet where I manipulate a number of other sheets with that "source data." I have created a drop down with all of the names of the sheets I need to reference.

I need to create a formula that changes based on this dropdown which includes sheet names.

enter image description here

If the formula was ='Sheet1'!E5 + 'Sheet1'!G5

But Sheet1 would be populated form the dropdown and E5 and G5 would just work normally I would assume. I am at a loss.

I have messed around with some INDIRECT commands but I can't seem to make that work. Not sure if that's the proper route.

Thank you for any help you can provide.

Upvotes: 0

Views: 34

Answers (1)

COY
COY

Reputation: 704

Example:

=INDIRECT("'02/03/2020 - 08/03/2020'!C10", TRUE)
=INDIRECT("'"&<reference cell>&"'!C10", TRUE)

Or another more flexible way:

=INDIRECT(ADDRESS(10, 3, 0, TRUE, "02/03/2020 - 08/03/2020"))
=INDIRECT(ADDRESS(10, 3, 0, TRUE, <reference cell>))

Upvotes: 1

Related Questions