VLOOKUP Not Referencing Correct Row When Rows are Sorted

Hello all,

I have a large table and I'm trying to sort data. Everything is sorted correctly, but my first column (VLOOKUP formula) isn't referencing the correct row when another column is sorted from largest to smallest.

For example:

My first cell has the formula =VLOOKUP(K1, $R$1:$W$1050$, 3, false).... when I sort the data, the vlookups are picking up the original location of the data rather than the new sorted location (So for the data in the first row, it goes from first to very low on the list, but it's pulling from the original location rather than the new location)...

Without locking in every single row manually with "$," how can I make sure the formula stays with the correct data? Thanks

Try

=VLOOKUP('Sheet Name'!K1, $R$1:$W$1050$, 3, false)

Where Sheet Name is the name of the sheet K1 resides on.

The actual formula I have is the following:

=vlookup('All Players'!K8,Other!$C$3:$I$6956,7,false)


So I guess that solution isn't needed since the sheet name is in the formula. Sorry, I should have specified this earlier. I'm just completely stumped on this.

ok, WHICH data is being sorted, on All Players, or on Other ?

Can you post a sample workbook with Before and After examples ?