find 3rd highest value and return adjacent cell

[ste33uka]

Hi i would like to find the 3rd highest value from column A1:A100 and return the value of the adjacent cell from column D.
Hope someone can help
Thanks

 

[Larry Haydn]

In cell D1, enter this formula:
=LARGE($A:$A,3)

 

[Phuoc]

Maybe?

=VLOOKUP(LARGE(A1:A100,3),A1:D100,4,0)

 

[Larry Haydn]

oops! I missed the other part.
Phuoc is correct.

 

[ste33uka]

Maybe?

=VLOOKUP(LARGE(A1:A100,3),A1:D100,4,0)

Thanks alot, thats great!