Q
R
S
T
U
1
1
2
3
4
2
a
100
200
100
3
1
2
4
b
50
25

changed the formula to...
=IFERROR(INDEX($D$2:$D$6,MATCH(R$1&Q4,INDEX($B$2:$B$6&$C$2:$C$6,0),0)),"")