What am I doing wrong with this Index/Match

[JeffGrant]

Can somebody please tell me why this simple Index/Match isn't working. I can't seem to see the forest for the trees

Book1
	B	C	D	E	F	G	H
2		1	2	3
3	1	a	b	c		Column Look Up	1
4	2	d	e	f		Row Look Up	1
5	3	h	i	j		Result	#N/A
Sheet1

Cell Formulas
Range	Formula
H5	H5	=INDEX(C3:E5,MATCH(1,(H3=C2:E2)*(H4=B3:B5),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

Please note that this is entered as an array formula.

Thanks for your patience

 

[Fluff]

You are mixing rows & column, try

=INDEX(C3:E5,MATCH(H4,B3:B5,0),MATCH(H3,C2:E2,0))

 

[JeffGrant]

Thanks Fluff. That is perfect. Works great. I have not seen syntax like that before. Is that syntax only available in 365?

 

[Fluff]

No, that's the standard syntax for the index function when isolating rows & columns.