I have two sheets in my Google spreadsheet: Meal Plan and Recipes.
Meal Plan looks like this:
Recipes looks like this:
I would like to write a formula or function which allows me to select a meal from one of the 'Items' drop downs (in 'Meal Plan'!C2:C5) and have the 'Shopping List' field in that row populated with the 'Ingredients' values from the 'Recipes' sheet where the item selected matches the 'Meal' field in column A ('Recipes'!A2:A10).
Would this be a function or a formula?
=IF(C4="","", TEXTJOIN(";",1,FILTER(Recipes!$B$2:$B,Recipes!$A$2:$A=C4)))
or if you need cost=IF(C4="","", TEXTJOIN(";",1,FILTER(Recipes!$B$2:$B&" - "&Recipes!$D$2:$D,Recipes!$A$2:$A=C4)))