Bit of a weird request but I am trying to use google sheets filter function to filter data in one tab based on criteria in another.
I have 2 different dishes called A & B that have the same list of ingredients x,y,z,... In each dish we have different products A_2 & A_1. I want the filter to populate the same list of ingredients twice for A_2 & A_1. See example spreadsheet here: https://docs.google.com/spreadsheets/d/1IjprF0yeBLFNC7M0VXyoRWNP9rmTr1qyson_1LnCWew/edit?usp=sharing
It is not an option to populate the 'ingredient list' tab by product type rather than dish type as we have many dishes so this adds multiple product entries. Maybe there's a way with count? e.g. if count = 2 then return all ingredients twice
I hope that makes sense thanks!