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.


1 Answer 1


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


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


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

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