Hi guys,
On Sheet1 I have a list of products in row A, with all of the ingredients in the rows below.
In Sheet 2 I have a list of ingredients in row A.
I would like a list of matching products to appear below each ingredient, if it is an ingredient used for that product.
Any help is greatly appreciated, I can't figure it out!
Note - I have made sure that all the ingredient names are identical to the first row in Sheet2.
Many thanks,
Danny
Bookmarks