I am trying to select the value of the cell to the left of max value of a column in Google sheets. Please see attached sample code and expected result:


1 Answer 1


Please check your Google Sheet, I propose such solution: =INDEX(A1:A5,MATCH(MAX(A2:B5),B1:B5,0)): INDEX() returns the content of a cell specified by row and column offset. So as arguments you need to put:

  1. Reference range
  2. MATCH() will give you the relative position of the value, in this case, the MAX() value. Put 0 as the final argument as you need to find the exact value and your range is unsorted

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.