Mulitple index and match

[yorkam]

Any help would be much appreciated as I have a questions which I am trying to pill through data from one sheet onto another.

I have a list of job roles in rows, with a criteria in columns in my data sheet.. in my summary sheet based on a filter I would like to pull the information through.

As example
Job accountant with condition of grade b which is in the drop.down filter so answer should be 1200

In the data I have
Job role grade a grade b
Accountant 1000 1200
Finance mgr 1400 1500

Trying to use index and match but constantly get an #n/a
=index(data range,match(Job role,job role data range,0),match(grade in the filter box,grade header row,0))

Any help from thr group would be appreciated.

 

[etaf]

=index(data range,match(Job role,job role data range,0),match(grade in the filter box,grade header row,0))
should work
=INDEX(B2:C3,MATCH(E2,A2:A3,0),MATCH(F2,B1:C1,0))

Book19
	A	B	C	D	E	F	G
1		Grade A	Grade B
2	Accountant	1000	1200		accountant	grade b	1200
3	Finance mgr	1400	1500
4
Sheet1

Cell Formulas
Range	Formula
G2	G2	=INDEX(B2:C3,MATCH(E2,A2:A3,0),MATCH(F2,B1:C1,0))