Index, Match, and Large

I have a column range, X9:X32 containin percentages. I have another column range to the left, D9:D32 containing the hours of the day. I need to look at the range, X9:X32 and find the highest percentage, and then return the time from the range, D9:D32.

Thanks for any help..

-ep

Got it!

=INDEX(D9:X32,MATCH(LARGE(X9:X32,1),X9:X32,FALSE),D9:D32,1)

Originally Posted by edwardpestian

Got it!

=INDEX(D9:X32,MATCH(LARGE(X9:X32,1),X9:X32,FALSE),D9:D32,1)

or

=OFFSET(D9,MATCH(LARGE(X9:X18,1),X9:X18,0)-1,0)

( a variation on yours)

---