Generate Unique list

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.

I have generated the unique list.

Please try this file.

Note: Im working on the dropdown list.

Hi Cavinaar,

Im not able to understand the mechanism of the values generated across A4:D13 for the dropdown placed in B1

OH!

The list for the dropdown is generated from the Recipes sheet, it's just a list of all the recipes. The values for A4-D13 are generated using a vlookup to get the ingredients from the recipes list. For the benefit of those who may read this later with the same issue, here is how it works:

* A recipe is chosen in the dropdown, which fires the VLOOKUP in A4 to pull the Quantity of the first ingredient of the recipe listed in the dropdown.

* The rest of the range is populated based on whether there is anything in the related cell (for instance, B4 checks A4 and if it isn't empty is uses a VLOOKUP to get the name of the first Ingredient.

The rest simply follows suit...with a twist.

A6 checks whether B4 is listed in the Base_Ingredients and if it isn't (the ISERROR part), it looks in the recipe list for the value in A4 (the VLOOKUP part). The process repeats itself through the rest of the range until no more recipes are left (giving me the raw data for the unique list I was trying to put together).

On another note, after a slight bit of tweaking with the references, the list is now working perfectly (other than missing a bit of data in the recipes which is causing #N/A errors in sheet 3, but that is easily fixed by finding and then entering the data).

Marking this one as solved and definitely upping rep for you.

Thanks a million