2

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?

player0
  • 124,011
  • 12
  • 67
  • 124

1 Answers1

1

try:

=HLOOKUP(A2; E1:F2; 2; 0)
player0
  • 124,011
  • 12
  • 67
  • 124
  • This works, thank you! Is it possible to make the index value dynamic to the row it is on? It is currently set to 2, but if i drag the row down the index value remains the same. `=HLOOKUP(A5, $E$1:F5, 5, 0)` for example when dragging the cell down the row 5, i had to manually update the index to 5. –  Mar 14 '22 at 08:43
  • @John sure. instead of `2` use `ROW(A2)` – player0 Mar 14 '22 at 11:54
  • 1
    ah! so simple ha! nice thanks –  Mar 14 '22 at 12:17