Index Match For Multiple Criteria

I have a spreadsheet that keeps track of production. I need an index match formula in row B13:U13. This is the formula I tried using but it didnt work.

=index('9HP Production Sequence'!$1:$1048576, match('Hot Parts'!B9,'Hot Parts'!B12,'9HP Production Sequence'!C:C,E:E,0)11)

. I want to index sheet 2 and match the parts number in sheet 1 row 9 along with today's day in row 12 and pull the information from sheet 2 column K. Can someone help me with this? Basically to summarize what I want from this formula is to pull the "Plan Qty" for today's date from the production plan "Sheet 2" to row 13 in sheet one using the part numbers in row 9 and the date in row 13 as a reference took.