Generate Unique list

[Cavinaar]

I am trying to generate a unique list based on whether the data from one range is included in another range. I also want to create a SUM of each value.

In the workbook:

* Sheet 3 is the one I am trying to get the list in (and for illustration has sample list).

* Column 1 in Ingredients is the list I want to compare to.

* The range A4-D13 in Sheet 3 is dynamic based on the drop down in B1 and is the data I want to pull the list from.

Hope this makes sense. Reply if more information is needed.