=VLOOKUP(MAX(A1:A100),A1:E100,5,0)

adjust your range to suit


"wsturdev" wrote:

I have a table of cells:

A B C D E
1/1/07 5
1/15/07 6
2/1/07 3
(empty) 2
(empty)
(empty)
(empty)
etc.
What formula do I use to look up the highest value in column A and retrieve
the value from THE NEXT ROW in column E. (I need to retrieve the 2)