Numbers Calculation from Food Items

Question

Level 1

11 points

Numbers Calculation from Food Items

Can anyone provide the formula needed to successfully get the following data table to work. Image attached

Making a calendar with Daily Meals. Variables are the various food items available for Breakfast, Lunch, Dinner and 3 snacks. Each meal for each day of the week has the same items to choose from. Each meal has a calorie and carb amount associated with it in my other table.

How can I get a total for each (cal and carbs), to add up, based on the Pop-up menu item chosen per meal. It would reference the 2nd table, which could be invisible or on another sheet.

Posted on Feb 25, 2024 11:48 AM

Reply

Answer 1

Yellowbox

Level 7

21,939 points

Feb 25, 2024 9:25 PM in response to kernelpaniq

Hi kernelpaniq,

Perhaps a different layout will make this easier.

Table 1 contains the choices for each meal, with the meal listed in Column A. I have reduced the choices to 2 for each meal, just to make a smaller table for this screen shot.

Formula in Daily Menu C2 is XLOOKUP($B2,Table 1::$B,Table 1::C,"Not found",0)

Fill right to D2 and fill down.

XLOOKUP: XLOOKUP – Apple Support (AU)

Regards,

Ian.

Reply

Numbers Calculation from Food Items

Similar questions