Perhaps

=INDEX(E2:E101,MATCH(MAX(A1:A100),A1:A100,0))

One alternative is:

=OFFSET(E1,MATCH(MAX(A1:A100),A1:A100,0)+1,0)

Scott

wsturdev wrote:
Your suggested formula pulls back the 3 from column E of the same row as the
highest date value in column A.

Ron Corderre's post gave me the correct formula.



"Teethless mama" wrote:

=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)