Fine the Max Value and corresponding date in unsorted arrays

[Fardan]

Hi,

I want to fined the max value from A2, A4, A6, A9 and display it in C1, and fined the corresponding time in B and display it in D1. As you can see A is not ordered, what function I can use for D? Since I can use =Max(a2,a4,a6,a9) for C1.

Thank you

[Pete_UK]

Try this:

=INDEX($B$2:$B$9,MATCH(C1,$A$2:$A$9,0))

or you could use VLOOKUP:

=VLOOKUP(C1,$A$2:$B$9,2,0)

Hope this helps.

Pete

[FDibbins]

Hi, welcome to the foum

As you can see A is not ordered

Not sure if you tried to attrach a WB, but nothing came through - so no, we cant see lol

Anyway, you could use vlookup or index/match for this. Without your sample data to play with, this is a guess...
=VLOOKUP(Max(a2,a4,a6,a9),$A$2:$B$9,2,0)
or =VLOOKUP(C1,$A$2:$B$9,2,0)
or
=INDEX($B$2:$B$9,match(Max(a2,a4,a6,a9),$A$2:$A$9,0))or
or=INDEX($B$2:$B$9,match(C1,$A$2:$A$9,0))