simple index match

[bmuddy2]

hi
im looking for a formula to put in C2 and drag down to C7. it should look at A2 and B2 then look at the data below in A9:A35 and display whats to the right in the column C.
I haven't used this in a long time and seem to have forgotten the basics.

Book1
	A	B	C
1	Press	Part #	cavities
2	C000	20985261	1
3	C000	22807140	2
4	C00	23442194	1
5	C00	15733061E
6	C01	1579 0864M
7	C01	20777301E
8
9	C000	20985261	1
10	C000	22807140	2
11	C00	23442194	1
12	C00	15733061E	4
13	C01	1579 0864M	2
14	C01	20777301E	2
15	C02	23273166	2
16	C02	3166M	2
17	C03	23332561	4
18	C03	22744901	2
19	C04	22744901E	2
20	C04	25882462E / 3E	1
21	C05	84076489	2
22	C05	90925677 / 8	4
Sheet2

 

[alansidman]

Use this formula ={INDEX($D$9:$D$22,MATCH(1,(B2=$B$9:$B$22)*(C2=$C$9:$C$22),0))}

You will enter this holding down the Ctl + Shift + Enter at the same time. This will produce the curly brackets for this array formula. Do not attempt to add the brackets manually as that will not work.

 

[bmuddy2]

thank you very much