@Tomas_Jansson you’re looking to get the list [Apple, Banana, Kiwi]
, since these are the fruits used in salads listed? I would recommend doing this the inverse way.
Instead of selecting which fruits are in a salad, select which salads a fruit belongs to. You can use the same multiple lookup column.
Then, to get the list of ingredients which are used, simply use =Fruit.filter([Used in?].IsNotBlank())
. In the “Recipes” table, use =Fruit.lookup([Used in?], thisRow)
to see the ingredients of each recipe.
I’ve attached a screenshot of my two tables—let me know if you have any questions!