Is it possible in Google Sheets to write a formula that calculates the cell to fetch based on the value of another.
In this case I would want cell B2 to print the value of e2 so be something like:
='a2'2
Is this possible in Google Sheets?
-
Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. You can even upvote the answer. If you don't have enough reputation, your upvote will show up later, once you reach enough reputation points.– marikamitsosCommented Mar 16, 2022 at 16:56
Add a comment
|
1 Answer
Try this formula in Cell B1:
=indirect(A1&1)
The formula consists of two parts:
A1&1: this creates a string value of the cell address (E1) to be referenced.indirect(): Returns a cell reference specified by a string.
