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?
CodePudding user response:
try:
=HLOOKUP(A2; E1:F2; 2; 0)