I have result of small function but now need corresponding value from result of small func

Hi

I have small (nth) value and then trying to result corresponding data from another column.
If you look at the attached, I'm struggling to get the correct data in Cell B2:B11. I've manually entered the data for your reference.

More details:
C2:C15 - I've done a lookup for agent (A14), TAM, and using Small function to rank the value (H:H) for various companiesG:G)
Then, B2:B11, I'm trying to find the companies associated to result in C2:C11

Thanks.

Put into B2:

Formula:

Please Login or Register  to view this content.

and accept with Ctrl+Shift+Enter (is array formula, you should see {} around it) and drag it down.
Should works.

Please try at
B2
=INDEX(G:G,AGGREGATE(15,6,ROW($F$2:$F$35)/($F$2:$F$35=A$14)/($H$2:$H$35=C2),COUNTIF(C$2:C2,C2)))
C2
=AGGREGATE(15,6,$H$2:$H$35/($F$2:$F$35=A$14),A2)

Drag B2:C2 down