distribute points according to results of the stage

[strooman]

I want to distribute points among the riders according to the ranking of the stage. The lay-out:

Ranking of the stage in column A:E
My rider selection in column G:J
Points to display in column L:Q (Here I want to display the results, the points)

When a team in column J is present in column D give the rider it's points in column L (according to the fixed point chart in E).
Example, ARLEY BERNAL GOMEZ Egan is in TEAM INEOS so he get's 17 points because TEAM INEOS is second place in the ranking.

Additional, when a rider is in the winning team (which is TEAM JUMBO - VISMA) that rider get's an additional 5 points. Display that in Column N

Question, what formula do I need in column L and column N to accomplish that?

Row\Col

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

P​

Q​

1​

RiderId

Rank

Rider

Team

Points

RiderId

Rider

Status

Team

Stage

Team

Mountain

Sprint

Top5

Penalty

2​

81​

1​

KRUIJSWIJK Steven

TEAM JUMBO - VISMA

20​

2​

ARLEY BERNAL GOMEZ Egan

Leader

TEAM INEOS

17​

3​

1​

2​

THOMAS Geraint

TEAM INEOS

17​

86​

MARTIN Tony

member

TEAM JUMBO - VISMA

20​

5​

4​

21​

3​

ALAPHILIPPE Julian

DECEUNINCK - QUICK - STEP

14​

31​

BARDET Romain

member

AG2R LA MONDIALE

5​

141​

4​

MATTHEWS Michael

TEAM SUNWEB

11​

84​

GROENEWEGEN Dylan

member

TEAM JUMBO - VISMA

20​

5​

6​

181​

5​

ZAKARIN Ilnur

TEAM KATUSHA ALPECIN

8​

41​

NIBALI Vincenzo

member

BAHRAIN - MERIDA

2​

7​

91​

6​

URAN Rigoberto

EF EDUCATION FIRST

5​

81​

KRUIJSWIJK Steven

member

TEAM JUMBO - VISMA

20​

5​

8​

111​

7​

VAN AVERMAET Greg

CCC TEAM

4​

101​

YATES Adam

member

MITCHELTON - SCOTT

9​

51​

8​

PINOT Thibaut

GROUPAMA - FDJ

3​

11​

SAGAN Peter

member

BORA - HANSGROHE

10​

41​

9​

NIBALI Vincenzo

BAHRAIN - MERIDA

2​

141​

MATTHEWS Michael

member

TEAM SUNWEB

11​

11​

71​

10​

FUGLSANG Jakob

ASTANA PRO TEAM

1​

21​

ALAPHILIPPE Julian

member

DECEUNINCK - QUICK - STEP

14​

12​

71​

FUGLSANG Jakob

member

ASTANA PRO TEAM

1​

13​

111​

VAN AVERMAET Greg

member

CCC TEAM

4​

14​

121​

MARTIN Daniel

member

UAE TEAM EMIRATES

15​

1​

THOMAS Geraint

member

TEAM INEOS

17​

16​

122​

ARU Fabio

member

UAE TEAM EMIRATES

17​

62​

VALVERDE Alejandro

member

MOVISTAR TEAM

18​

161​

EWAN Caleb

member

LOTTO SOUDAL

19​

61​

QUINTANA Nairo

member

MOVISTAR TEAM

20​

88​

VAN AERT Wout

member

TEAM JUMBO - VISMA

20​

5​

21​

51​

PINOT Thibaut

member

GROUPAMA - FDJ

3​

22​

28​

VIVIANI Elia

member

DECEUNINCK - QUICK - STEP

14​

23​

126​

KRISTOFF Alexander

member

UAE TEAM EMIRATES

24​

181​

ZAKARIN Ilnur

member

TEAM KATUSHA ALPECIN

8​

25​

211​

BARGUIL Warren

member

TEAM ARKEA - SAMSIC

 

[Fluff]

How about in L2
=IFERROR(INDEX($E$2:$E$11,MATCH(J2,$D$2:$D$11,0)),"")
and M2
=IF(J2=$D$2,5,"")

 

[strooman]

Ha ha, thank you very much Fluff. Sometimes it's so simpel but for the moment I couldn't see the wood for the trees and I focussed to much on the details.
Your solutions works perfect. Thanks.

 

[Fluff]

You're welcome & thanks for the feedback