formula to get the name of the next player with the same score

Hi aydaria,

Try using below formula:-

Formula:

{=INDEX('Player Score'!$C$5:$C$114,SMALL(IF('Player Score'!$DY$5:$DY$114='Game Record'!$L27,ROW('Player Score'!$DY$5:$DY$114)-4,""),ROW($A1)),1)}

See attached- ScoreboardDummy.xlsx

regards,
DILIPandey

<click on below 'star' if this helps>