Lookup criteria matching in rows and columns

I have 2 worksheets, 1 containing a list of items and qty's needed and another showing which qty's are in stock. I need to know which items from sheet 1, show up in the matching qty column in sheet 2.

See Example attached

I need a formula in C2 of sheet 1 that looks at sheet 2 to find the matching item #, then looks at the column headers for the same # as the qty, if an "x" is in the same row as the item # I want to populate C2 of sheet 1 with a yes, if not a no. The important thing is that the Qty in the header of sheet 2 must match exacly, not just be equal to or greater than.

I'm stuck, thanks in advance.

JuJuBe

Try:

=IF(SUMPRODUCT((Sheet2!$A$2:$A$20=A2)*(Sheet2!$B$1:$G$1=B2)*(Sheet2!$B$2:$G$20="x")),"Yes","No")

this will also put a "No" if the items are not matched at all in the table.

copied down.