1

enter image description here

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?

1
  • 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. Mar 16, 2022 at 16:56

1 Answer 1

1

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.

snapshot

1
  • Ah ok so the & character there is a concatenation operator?
    – John
    Mar 14, 2022 at 8:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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