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

[billfloyd806]

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