CODEWITHSUNDEEP
arraysgoogle-sheetsindexingvlookupindex-match
user1037355
user1037355

Reputation:

get google sheet cell value based on value of other cell

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?

Upvotes: 2

Views: 3135

Answers (1)

player0
player0

Reputation: 1

try:

=HLOOKUP(A2; E1:F2; 2; 0)

Upvotes: 2

Related Questions