copying related cells after using a sorting using a formula

[DRFILL]

Hello again,

Here is my next problem:

I have a set of list set up that shows

Year Week Team Player Points


I am using the formula

Please Login or Register  to view this content.

to sort all of that data by points. What I need now is to get the Week Player and Team data that corresponds to the points in the proper cells. Any Ideas?
Thank you

[zumbalj]

If I understand your goal correctly, the formula VLOOKUP can help you. If you do this, you'll have to make sure the points column is on the left. You can do this by hiding a column full of the formula =[cell that points is in] on the left of the other data if you don't want to change the order the columns are in.

[DRFILL]

I was just about ready to look a VLOOKUP before I went to work, so I was looking in the right direction.

If i am understanding what you want me to do I am just adding another points column to reference all of the others. Will the fact that I have multiple players with the same score cause issues with this? and if so should I add a referance cell to pull form or will the ROW/ROWS function cover this?

I know I am getting way over my head with this file but I know it can be done, and figuring it out sounds like fun

[zumbalj]

If you upload a sample spreadsheet (make up sample data so you don't have to share anything sensitive/confidential), it would be easier to discuss.

[DRFILL]

FFLSample.xlsx

Ok, now let me explain it. the first two lines will be hidden. I am using them to reference cells on a tab I took out to cut down on the size. on the left side will be the data that is being pulled for that tab on the right side is where I want to sort everything. I just added the Reference cells to solve a another issue I was having but I figure if they are there they could be useful. I need to get the three empty columns on the right side filled in but they need to come from the same row as the points column.

That is where I get stuck.

What I am thinking now that I added the Ref Cell Column is to use it as the primary key for the table. By doing this I could insert another column before Rank and have the formula sort the points column but output the Key for that row. With the Key I could use VLOOKUP to fill in the rest of the columns.

But I have no idea what needs to be nested together to make the formula work.