Formula to return value in correlation to oldest date.

[jspence757]

I need a formula to return the value adjacent to the cell containing the oldest date. So it would look like below

A B
1 03-01-2011 2
2 03-02-2011 7
3 03-03-2011 3


Formula would return 3

 

[T. Valko]

I need a formula to return the value adjacent to the cell containing the oldest date. So it would look like below

A B
1 03-01-2011 2
2 03-02-2011 7
3 03-03-2011 3


Formula would return 3

Try this...

=INDEX(B1:B3,MATCH(MAX(A1:A3),A1:A3,0))

 

[Oaktree]

Welcome to the board.

If you're looking for the oldest date, I'd think it would return 2 from the 03-01 date.

Try:

=INDEX(B1:B3,MATCH(MIN(A1:A3),A1:A3,0))

To return 3 for the latest date, change MIN to MAX:

 

[jspence757]

Stupendous....Thanks so much for your help. Perfect. Had myself stumped.

 

[T. Valko]

Stupendous....Thanks so much for your help. Perfect. Had myself stumped.

You're welcome. Thanks for the feedback!