1

Is it possible to use a cell text as a sheet reference in Google sheets. I have a spreadsheet with many sheets and want to reference a sheet name from text in a cell rather than having to put the sheet name in each time.

2

Somewhat guessing what you require (examples often help) if say you have a couple of sheets named:

Sheet2
Sheet3

and those names in A1 and A2 of Sheet1, then a formula like:

=indirect(A1&"!B2")  

in Sheet1 should return the value of B2 from Sheet2 and if copied down one row, the value of B2 from Sheet3.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.