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
Bookmarks