How to create the same algorithm for a different cell, but add to same cell

Question

I'm a real newbie to this. This is VERY long winded. I want to do this exact piece of code but for L16,17,18 and 19 (currently for L15) All of these return to L20, But past L15, I can't get them into L20... This is really hard to word!

=IF(L15=1,+5,IF(L15=2,+4,IF(L15=3,+3,IF(L15=4,+2,IF(L15=5,+2,IF(L15=6,+2,IF(L15=7,+1,IF(L15=8,+1,IF(L15=9,+1,IF(L15=10,+1))))))))))

Breakdown: this: =IF(L15=1,+5) is interpreting a race. If I come 1st, I gain 5 Points. and so on (see above code)

would greatly appreciate the help!

Just to confirm, I am using Google Sheets.

Answer 1

Posting comment as an answer:

Table looks like

Place    Points
1        5
2        4
3        3
4        2
5        1

Highlight the COLUMN for Place and name the range as "Place", same for points as "Points".

Your formula would look like:

=Index(Points,Match(L15,Place,0))

---

Related to this being updated to include "google sheets", I do not know if the named range will work there, but the formula would work. You would then need to use actual ranges, rather than named ranges, such that:

=Index(Table!B$2:B$6,Match(L15,Table!A$2:A$6,0))