Good Day to all,

I am working on a project for a foods partner which requires me to list ingredients with possible allergens in them. I have made a list of the possible allergens, and what category they belong in. What I need is a macro or formula that will match any allergen ingredients in a particular item

On one tab entitle DLR Items List, I have a list of allergen ingredients.

On another tab entitled DLR Product Ingredient Viewer, I have the automated Ingredient sheet. I need a macro or formula that evaluates the ingredients on this page, and matches them to the allergen list on the other page (Photo 2 Attached)