1

I have the following example table:

A | B    
a | 5    
b | 3    
c | 1    
d | 9  <=== expected result   
e | 0    
f | 4

So it should display d as in the other column 9 is the highest value.

2
1

You can use the following formula to accomplish that.

Formula

=QUERY(B2:C7, "SELECT B, C ORDER BY C DESC LIMIT 1")

Screenshot

enter image description here

Explained

The QUERY formula shows column B and C, sorts the range descendingly (ORDER BY) and limits the result to just one row (LIMIT 1).

Example

I've created an example file for you: find max and show row

0
1

An alternative ("Excel style"):

=index(A:A,match(max(B:B),B:B,0))

max(B:B) to find the maximum value in ColumnB (ie 9)

match(max(B:B),B:B,0) to find the row number where there is an exact match for 9 (the first found)

=index(A:A,match(max(B:B),B:B,0)) to apply that row number (relative to the start of B:B) to ColumnA (relative to the start of A:A) and return the value there - d.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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