Matching the Searched Value to the Adjacent Column

[vamber001]

Hi,

I'm trying to search for the maximum numeric value in one column but I
want the data in the adjacent left column which is a Time variable to
be displayed as the result. How do I achieve this? I can only think of
MATCH, VLOOKUP. The data is quite large.

Thank you very much for your help in advance.

Richard

 

[Don Guillett]

try this idea
=INDEX(C:C,MATCH(MAX(D),D))