Points for positions in different competitions

I'm looking for a specific function that will help me out with a problem. I have columns of 10 different rankings of teams (50 teams total). I want to assign a point value to the team who got in 1st, 2nd, 3rd, .... all the way down to 50th. Once all of the points are given for each team, I want to be able to display a list of total points for each team, and organize them from most points total to fewest points total.

So, for example let's say that in column 1 I have the rankings of 1st place as Team 1, 2nd place Team 2, and 3rd place Team 3 (continue all the way down to Team 50). In the next column, I have the rankings of 1st place is Team 3, 2nd place is Team 1, 3rd place is Team 3, etc. For each competition, I want the first place team to get 50 points, 2nd place gets 49 points, 3rd place gets 48 and so on. Once everything is entered, I want to be able to lookup in the columns for a team name, and assign it the correct points and add all of their points together.

Hopefully I described what I'm looking for! Thanks in advance!