Trying to locate Top 3 values, then display text from adjacent columns

[DraygoB]

Assuming the data below starts in column A. I'm trying to write a formula in rows 1-3 that will look in Column D, find the top 3 in rank, then provide the adjacent from in columns A,B,C,E, and F. Help?




[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]Tiger [/TD]
[TD="class: xl66, width: 64"]Woods[/TD]
[TD="class: xl66, width: 64"]Golf[/TD]
[TD="class: xl66, width: 64"]10[/TD]
[TD="class: xl66, width: 64"]Birdie[/TD]
[TD="class: xl66, width: 64"]Eagle[/TD]
[/TR]
[TR]
[TD="class: xl66"]Michael[/TD]
[TD="class: xl66"]Jordan[/TD]
[TD="class: xl66"]Basketball[/TD]
[TD="class: xl66"]15[/TD]
[TD="class: xl66"]Dunk[/TD]
[TD="class: xl66"]Jumper[/TD]
[/TR]
[TR]
[TD="class: xl66"]Babe[/TD]
[TD="class: xl66"]Ruth[/TD]
[TD="class: xl66"]Baseball[/TD]
[TD="class: xl66"]12[/TD]
[TD="class: xl66"]Homer[/TD]
[TD="class: xl66"]Double[/TD]
[/TR]
[TR]
[TD="class: xl66"]Wayne[/TD]
[TD="class: xl66"]Gretzky[/TD]
[TD="class: xl66"]Hockey[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl66"]Goal[/TD]
[TD="class: xl66"]Assist[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Hi, welcome to the board.

Assuming there are no duplicate entries in column D . . .

You can use the LARGE function to identify the largest value, second largest, and so on.
For example
=LARGE(D1:D4,1)
=LARGE(D1:D4,2)

and so on.

Let's assume you put the first example of the above formula in cell G1.

You can then use a combination of INDEX and MATCH to return the corresponding data for the largest entry, and so on.
Like this for column A . . .
=INDEX(A1:A4,MATCH(G1,D1:D4,0))
Adapt this for the other columns as appropriate.

 

[DraygoB]

You Sir, are the man. Thank you very much.