Easiest solution is probably to add a helper column where you calculate the rank of each player.

To make formulas auto-updating when you add new items, and also making them more readable I suggest to convert your raw data range to list (insert - table).

• the formula for rank:
  =RANK.EQ([@points],[points])+COUNTIF($F$2:F2,[@points])
• the formula to get player names and points (same formula in both columns):
  =INDEX(Table1[[players]:[points]],MATCH($A3,Table1[rank],0),COLUMN()-1)

Of course you can do it also without helper column but thaat would make your formula in column B much more complicated.

Easiest solution is probably to add a helper column where you calculate the rank of each player.

To make formulas auto-updating when you add new items, and also making them more readable I suggest to convert your raw data range to list (insert - table).

• the formula for rank:
  =RANK.EQ([@points],[points])+COUNTIF($F$2:F2,[@points])
• the formula to get player names and points (same formula in both columns):
  =INDEX(Table1[[players]:[points]],MATCH($A3,Table1[rank],0),COLUMN()-1)

Of course you can do it also without helper column but that would make your formula in column B much more complicated.

Update

Formula without helper column:

=OFFSET(Table2[[#Headers],[players]],SMALL(IF(Table2[points]=C3, ROW(Table2[points]),""), COUNTIF($C$3:C3,C3))-2,0)

This is an array formula, you need to enter it with CTRL+SHIFT+ENTER.