Trying to set up a Tipping spreadsheet

Bit of an excel noob.



I use excel online and basically i'm trying to set up a spreadsheet so myself and a few mates can do a horse tipping competition.
eg
10 points for 1st
6 points for 2nd
4 points for 3rd
2 points for 4th
0 points for the rest

Lets say in race 1, Results were 6,5,4,3

Instead of manually having to go through selections and entering 10 points next to everyone who selected horse, i'd like to just enter the results of the race in Sheet 2, essentially giving anyone with selection 6 10 points. Anyone who selected 5 gets 6 points, 4 gets 4 points and 3 gets 2 points with everyone else remaining on zero.
(it's not as confusing if you look at the link above to the spreadsheet with how ive got it laid out)

I'm not quite sure what the forumla i should be using is as my excel skills go about as far as sum.

Cheers for the help if you can understand what i mean.

(apparently i can't post any links or images until i've posted a few times, so that makes this incredibly difficult, hopefully someone understood what i meant)