Multiple ROWS and COLUMS

[Trebby]

Hi All,

Please can you assist.

I am trying to pull a number of rows and columns together based on criteria within a INDEX,MATCH formula.

A	B	C	D	E
Code	Name	Jan-17	Feb-17	Mar-17
0	John	10	20	30
1	John	20	30	40
2	John	30	40	50
0	Ben	5	10	15
1	Ben	10	15	20
2	Ben	15	20	25

<tbody>
</tbody>

Results

G	H	I	J
		Jan-17	Feb-17
0	John	10	#REF !
0	Ben	5	#REF !

<tbody>
</tbody>

For January I am using the following formula

=INDEX($C$3:$E$8,MATCH($H3,$B$3:$B$8,0),MATCH($G3,$A$3:$A$8,0),MATCH($I$2,$C$2:$E$2,0))

When dragging this over for Feb I get #REF !

=INDEX($C$3:$E$8,MATCH($H3,$B$3:$B$8,0),MATCH($G3,$A$3:$A$8,0),MATCH($J$2,$C$2:$E$2,0))

Can you advise what I am doing wrong or maybe suggest an alternative way of doing this?

Thanks for your help in advance.

 

[njimack]

Array formula, so confirm with ctrl+shift+enter:
=INDEX($C$2:$E$7,MATCH($G2&$H2,$A$2:$A$7&$B$2:$B$7,0),MATCH(I$1,$C$1:$E$1,0))

 

[Trebby]

Array formula, so confirm with ctrl+shift+enter:
=INDEX($C$2:$E$7,MATCH($G2&$H2,$A$2:$A$7&$B$2:$B$7,0),MATCH(I$1,$C$1:$E$1,0))

Worked like a charm... Thank you.