oops reading again, I see that your INDEX range is indeed a single column range.

I just noticed that your Players upload has only 1 sheet, so the formula I put together did not need a sheet name in it (because there is only 1 sheet in that file). But if you have more than 1 sheet, that formula will have a problem. Use this instead...
=IFERROR(INDEX([players.xlsx]players!A$2:A$30,MATCH($A2,[players.xlsx]players!$CE$2:$CE$30,0)),"")

but pull more than a single row if they exist
That part will not work with my formula, I will need to adjust it a bit. For that, can I ask that you upload another sample WB/s with samples of those too plz?