INDEX MATCH over multiple columns

[surkdidat]

I am trying (On Sheet6) to put a formula of INDEX MATCH

=INDEX('Sheet_4'!A:A,MATCH('Sheet_6'!G2,'Sheet_4'!C:C,0),MATCH('Sheet_6'!D2,'Sheet_4'!E:E,0))

So, I am trying to return Column A from Sheet 4.

D2 looks up Sheet 4, Column E
G2 looks up Sheet 4, Column C

Can anyone help, and advise where I am going wrong please

 

[hajiali]

try this.

Book1
	A
1	2
Sheet6

Cell Formulas
Range	Formula
A1	A1	=INDEX(Sheet4!$A:$A,MATCH(1,(Sheet4!$C:$C=G1)*(Sheet4!$E:$E=D1),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[surkdidat]

try this.

Book1
	A
1	2
Sheet6

Cell Formulas
Range	Formula
A1	A1	=INDEX(Sheet4!$A:$A,MATCH(1,(Sheet4!$C:$C=G1)*(Sheet4!$E:$E=D1),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thanks - works a treat!

 

[hajiali]

Glad I could help. Thanks for the feedback