Trying to return value based on two cells in one row matching two different cells

I have an issue I am trying to work through and would appreciate any assistance.

I have two sheets.

Sheet 1 contains master data:
Column B is product name
Column C is the list of ingredients
Column G is the quantity of ingredients

Sheet 2 is a table I am trying to populate:
Across Row 1 are all possible ingredients for all products
Down column A is list of all products.

I would like to fill the sheet 2 table out by having excel look at the Name of the product in column A and the ingredient in row 1 and see if that combination exists in sheet 1.
If the combination exists return the quantity from column G, if it does not exist return a 0.

There will never be a case where there is more than one match to both product and ingredient.

Thanks in advance and let me know if this is more information needed.

Anthony