I have a spreadsheet that has a leaderboard with 30 slots on it. I want it so that Each slot is worth a different amount of points(30 pts.-1 pt.). There are 10 teams all with 9 players on it.

I want to make it so when I enter a player on the leaderboard, every team with that player gets a certain amount of points depending on what cell their player is placed on the leaderboard. Right now I am stuck with two separate tables(the leaderboard and the team chart) on one sheet.