Firstly, I hope I'm posting this in the right place but I have a formula I'm struggling to build in Google Sheets. I think it's a combination of LOOKUP and IF functions but I'm not sure how to execute it.
The link to the sheet is attached.
What I'm trying to do is lookup product IDs from a supplier and use that to find the product's allergens, which are then combined in my Catalog sheet.
E.g.
Sheet - Catalog
Cell - K2
LOOKUP the 'sku' (A2) in 'All Products' sheet & IF "Does Contain" is visible in 'All Products' O3:Y3 show 'All Products' O2:Y2 seperated by comma
Result in K2 would look like: Sesame,Soya,Nuts
Idealy this would be possible as an array so that it then copied down for all products added to the 'All Products' sheet in the future.
Any help would be much appreciated.
Bookmarks