Shopping list from meal plan: Summing multiple values

Hey everyone!

Basically as part of my weight loss journey I am trying to create a bit more of a savvy meal plan so I don't have to rely on the same few meals week-in week-out. I've done all the data for this but would like to link it into a weekly shopping list so I can order this easily without having to go through each recipe. Basically as of now I have two tables, one as a meal plan (Monday > Sunday; Breakfast, Snack, Lunch, Snack, Dinner). The second tab is the ingredients for each recipe, ordered as per the below (an example).

So using the below example as the template for how the recipes are structured, I want to auto calculate the shopping list of ingredients based on the recipes in the meal plan (of which the names will be perfectly aligned to the name in Column A (meal).

Any advice on how this can be done? My thoughts are to list all the ingredients in a third tab and then use some formula to look up the recipes in the meal plan and then sum up the ingredients but not sure how to create this as I don't think a vlookup / sumif will work...?


Meal Ingredient Measurement
Hey everyone!

Basically as part of my weight loss journey I am trying to create a bit more of a savvy meal plan so I don't have to rely on the same few meals week-in week-out. I've done all the data for this but would like to link it into a weekly shopping list so I can order this easily without having to go through each recipe. Basically as of now I have two tables, one as a meal plan (Monday > Sunday; Breakfast, Snack, Lunch, Snack, Dinner). The second tab is the ingredients for each recipe, ordered as per the below (an example).

So using the below example as the template for how the recipes are structured, I want to auto calculate the shopping list of ingredients based on the recipes in the meal plan (of which the names will be perfectly aligned to the name in Column A (meal).

Any advice on how this can be done? My thoughts are to list all the ingredients in a third tab and then use some formula to look up the recipes in the meal plan and then sum up the ingredients but not sure how to create this as I don't think a vlookup / sumif will work...?


Meal Ingredient Measurement
Spaghetti Bolognese Spaghetti 500
Spaghetti Bolognese Mince meat 250
Spaghetti Bolognese Onion 2
Spaghetti Bolognese Pepper 2

Absolutely no intention of re-inventing the wheel, but when I had a Google I couldn't really find one that worked well for me. I'll have a search of the forum though and see if I can find one, thanks!

Thanks a lot - pretty much what I was looking for except is there not a way to sum up the values instead of listing them (i.e. the attachment in that threat lists the requirements as like 250g, 250g, 250g) is there no way to sum it? Also I wanted categories Breakfast, Snack AM, Lunch, Snack PM, Dinner categories - is that as easy as adding them in as additional rows in the "Meal Planner" sheet?

Is there an issue with posting it on more than one forum?

I don't want to reinvent the wheel but the worksheet shared by Ali wasn't exactly what I am looking for.

Came onto an excel help forum for help and feel like I'm committing a crime.

Ok fair enough for Cross posting, thanks for sharing the link.

The draft worksheet is below should give basic idea of what I am trying to do - the 'Shopping list' tab is blank as don't know what the best way is to calculate it (my initial comment is only how I thought it may work).