Do you mean the lookup_value 'All Players'!K8 in column K is sorted and move to other position, for example, K1?

Assuming the value of K8 is 100, try to type that value in the formula: = VLOOKUP(100,...)