Hello, and welcome to the forum!
Not a worry. You need two things to do this:
1) A table that lists the position and points earned
2) A VLOOKUP formula to search out the correct points awarded
I've done up an example for you, and I've wrapped the VLOOKUP in an IF(ISERROR()) syntax. This is the route for Excel 2003 & prior to return 0 if no suitable match is found.
Bookmarks