Index match match with additional Condition with another index

[Alex_Excel]

Hello,

I'm having trouble with my index formula..

Situation:
First table is data, second table is calculation

column
A B C D
Table range is A2:D6

		GSSE	GTRS
D	70417	50	100
D	160784	150	200
C	70417	250	300
C	160784	350	400
		GSSE	GTRS
D	70417	50	100
C	70417	50	100
D	160784	150	200
C	160784	150	200

<tbody>
</tbody>

The second table comes from these formulas:

		GSSE	GTRS
D	70417	=INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))	=INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))
C	70417	=INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))	=INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))
D	160784	=INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))	=INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))
C	160784	=INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))	=INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))

<colgroup><col span="2"><col span="2"></colgroup><tbody>
</tbody>

PROBLEM is: I get the same values for D and C in column A!!

How do I add an extra criteria so the result looks like the first table but only with formulas?

Extra: right now there is 2 times the letter D in column A. The number of times this value D appears in the column can change over time, the column is always sorted A-Z so all the values D will show under each other. Right now it's A3:A4 that contains the D, but if more D are added then the 4 will expand. Is it possible to include this in the answer please?
Same goes for C ofcourse ^^

Thank you!!

Much obliged,

Alex

 

[Alex_Excel]

Could anyone help me out pls?

Thx!

 

[Alex_Excel]

BUmp