Hello, Im trying to set up a spreadsheet to help calculate daily calorie needs, meal plans, fats carbs protein amounts and shopping list.

Ive made a table on sheet one with each food, with its calories, fats, carbs and protein. On sheet two ive made a table split into 6 meals down the left hand side and the different food types along the top. The idea being you enter a 1, 2 or 3 etc in each relevant box on the correct row for the meal and under each corresponding food you will consume.

I want to create a table below this showing the daily calories, fats, carbs and protein which will update depending on the foods you select above.

Ive tried my basic knowledge of Vlookup and If but thats about as much as i know.

If anyone could help it would be greatly appreciated.

Thanks