Index match formula for multiple criteria

Index%20match%20help(1).xlsx
Please see attached

=INDEX($C$2:$C$17,MATCH(1,IF(B24=A2:A17,IF(B2:B17=C24,1)),0))
Confirm Control+Shift+Enter

hi Nelly. what is the multiple criteria? what are you expecting to see? putting that in the file helps us. if you have YDA1 in F2 & Softwood (primed) in G2 as your criteria, try this array formula:
=INDEX($C$2:$C$17,MATCH(F2&G2,$A$2:$A$17&$B$2:$B$17,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

if the combination of F2 & G2 are always unique, try:
=SUMPRODUCT(($A$2:$A$17=F2)*($B$2:$B$17=G2)*$C$2:$C$17)

i'm giving you SUMPRODUCT because your profile says Excel 2003. but your file is xlsx. change your profile if you have upgraded. then you can use faster & more efficient formulas like:
=SUMIFS(C:C,A:A,F2,B:B,G2)

You are welcome.
Consider benishiryo solution as well.
(concatenation is slighly slower that IF)
Please add reputation if your satisfied with the solution.