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

[TABLE="width: 256"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]GSSE
[/TD]
[TD]GTRS
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]70417
[/TD]
[TD]50
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]160784
[/TD]
[TD]150
[/TD]
[TD]200
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]70417
[/TD]
[TD]250
[/TD]
[TD]300
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]160784
[/TD]
[TD]350
[/TD]
[TD]400
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]GSSE
[/TD]
[TD]GTRS
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]70417
[/TD]
[TD]50
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]70417
[/TD]
[TD]50
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]160784
[/TD]
[TD]150
[/TD]
[TD]200
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]160784
[/TD]
[TD]150
[/TD]
[TD]200

[/TD]
[/TR]
</tbody>[/TABLE]



The second table comes from these formulas:

[TABLE="width: 1204"]
<colgroup><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]GSSE[/TD]
[TD]GTRS[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]70417[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B11;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]70417[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B12;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]160784[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B13;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]160784[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(C$10;$A$2:$D$2;0))[/TD]
[TD]=INDEX($A$2:$D$6;MATCH($B14;$B$2:$B$6;0);MATCH(D$10;$A$2:$D$2;0))[/TD]
[/TR]
</tbody>[/TABLE]


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