Select the greatest value in the list and return a cell next to it

[Restyl]

Hi,

How could I go about taking my cell value in S33 and selecting the closest greater than value in T19:T30, then returning the corresponding Overload in the column to the left of the closest greater than value?

Which formulas would I use to achieve this?

Thanks in advance.

 

[Jak7217]

Can you flip the info in column S and T? If so...

In cell S33 =max(T19:T30)

In cell T33 =vlookup(S33,S19:T30,2,false)