Match 2 cell values on Sheet 1 and find two cells with same matching value on sheet 2

I have a workbook I'm working on. I need to look at the values in Sheet 1 cells A2 & B2, then look at sheet #2 find the same two values which could be in A3:A25 and C3:C25. When I find a match return the value in that matching row from sheet 2 cell E* (same row match was found).

Simpler way I guess to explain it If the Plant Code & Part Number match on Sheet 1, Find the same Row with the matching Plant Code and Part Number and Tell me the skid qty.

Sheet 1
SHEET1.jpg

Sheet 2
SHEET2.jpg

I've tried some Vlookup and Match but I can't seem to get anything to work. I'll take VBA or just a cell formula whatever will work.

I just filled in the values on sheet # 1 so you could see what I want the results to be! thanks

Try this array fomrula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter and not just Enter

or this normal formula

Please Login or Register  to view this content.

Here is another approach:

=SUMPRODUCT(($A$3:$A$60=A3)*($B$3:$B$60=B3)*(Sheet2!$A$3:$A$60=Sheet1!A3)*(Sheet2!$C$3:$C$60=Sheet1!B3),Sheet2!$E$3:$E$60)