locking a reference cell to row without formula
I am trying to limit the amount of formulas I am using because it has caused the sheet to slow to a crawl. What I am currently doing is using a vlookup(picture 2) to get the scores from picture 1 column d and bring them into the team page for all teams. I believe this formula is one of the biggest culprits slowing things. So what I am able to do is instead of vlookup using "=" and reference to that cell and then copy that all of the way down. And then I repeat that for all teams. Now picture 1 has 4860 rows with every team represented and picture 2 is 1 of 30 different team sheets. It all works fine until I sort column 1 of picture 1 by ascending order. That puts everything in order of date and no longer date by team. And that is where I lose what I am trying to do. So I can continue to use vlookup or index, match but those also cause it to take anywhere from 15-60 minutes when I input any scores. I hope this makes sense.