How to VLOOKUP with Multiple Criteria Using INDEX and MATCH

=INDEX(C4:H1159,MATCH(1,(C4:C1159=A2)*(D4:D1159=B2),0),6)

Basically your match is saying look for "true" if these two conditions are both "true".

When you enter the formula, don’t just press ENTER. Press CTRL+SHIFT+ENTER to tell Excel that it is an array formula. You can tell you’ve done it right because the entered formula will be surrounded in curly braces {}.

Reference:

http://superuser.com/questions/728000/index-match-based-on-2-criteria
http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-match/
http://www.exceltactics.com/vlookup-multiple-criteria-using-index-match/4/#Using-INDEX-and-MATCH-with-Two-Criteria