Nutrition Database + Meal Planner possible with Numbers? (dropdown menu etc.)

Here is one I made.

https://www.dropbox.com/s/m6zslyy2rtwnq9l/Nutrition.numbers?dl=0

First sheet ("Food Items") is the list of food items like Wayne was showing.

Second sheet ("Blank") is a blank table already set up with the pop up menu in column A and all the formulas. You duplicate this sheet when you want to make a new recipe or add up a day of food.

Other sheets are examples of "recipes" and daily intake.

To put new foods on the list in the first sheet,

1. Select column A of the "Food Items" and set the cell format to Text
2. Type in your new foods and their values in rows at the bottom. If you have a recipe from another sheet to be added to the list, go to that sheet and copy/paste the values from row 2 vs typing them in.
3. Sort alphabetically by column A
4. Select all of column A except the header cell and format as a pop up
5. Select one of the "-----" popups and copy/paste it into all of column A in the "Blank" sheet.

I started this with Numbers but have been using Excel instead because it is easier to add new foods to the list. You just type them in and sort the table. Excel's "data validation" adds them to its "pop-up" without me having to do anything additional. it takes two steps instead of five.

Create one table that has the list of foods and the corresponding entries for the Kcal, Protein, Carbs and Fat:

I'm going to enter made up information so I can confirm it works:

Now select the cells in the food column and include one black cell. Now convert these selections to a pop-up menu by opening the cell formatter:

now select the cell that is empty (in this case cell A9), copy. The cell formatted as a pop-up menu is on the clip board. Well use it shortly, so do NOT copy anything else.

Now create a new new table and title is "":

Convert the first row to a header row by selecting the "1" on the left and choosing the contextual menu item "Convert to Header row"

Now select column B2 by clicking the "B" at the top, then unselect the cell in the header row by holding the command key and single click cell B1

paste.

Now the food column should be full of pop-up menus that have the "blank" selection. You can confirm this by selecting one of the cells in column B to see that it has the pop-up menu icon:

If you click the icon, you'll see the pop-up menu:

Now lets add the look up part to get information from the table "Food List"

In the table "Menu", select cell D2, then enter the formula (or copy and paste from here):

=IF($B2<>"",$C2*VLOOKUP($B2, Food List::$A:$E, COLUMN()−2,0),"")

shorthand for this is:

D2=IF($B2<>"",$C2*VLOOKUP($B2, Food List::$A:$E, COLUMN()−2,0),"")

select cell D2, copy

select cells D2 thru the last cell in column G, paste

now enter a value in the column Portion" and select menu items from each pop-up menu in the food column