Example:  A    B1 john 62 ryan 53 kate 84 paul 1I want the formula that returns the text kate in A3, because the value in B3 is the highest in the range B1:B4. I would like to know also the same opperation but with the lowest value (i.e. B4 is the lowest, so I would get paul).
How to get the name of the row which is the mode in Google Spreadsheets?
google spreadsheets
For the highest value you can use:=INDEX(sort(A:B, 2, false), 1, 1)This first sorts and then retrieves the value from the first row and column of the sorted data.Using  the opposite sort order in the formula will yield the lowest value:=INDEX(sort(A:B, 2, true), 1, 1)