Hello all,
I'm trying to create a spreadsheet that will help my wife and I calculate food macros based off a single drop down box. The drop down box will have a food item and I would like to auto populate all the calories, fats, carbs and protein based off the drop down selection. Here is a quick example.
I have a chart with all the food macro information in it beside the food item. I'm not sure what formula/s to use to get to auto populate the cells.
When I choose the Peanut Butter 1 serving from the drop down box, I want it to fill in the rest from the chart below.
Just a quick example... Thanks in advance for your help!
<colgroup><col width="163" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5961;">
<col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" span="8">
<tbody>
</tbody>
I'm trying to create a spreadsheet that will help my wife and I calculate food macros based off a single drop down box. The drop down box will have a food item and I would like to auto populate all the calories, fats, carbs and protein based off the drop down selection. Here is a quick example.
I have a chart with all the food macro information in it beside the food item. I'm not sure what formula/s to use to get to auto populate the cells.
When I choose the Peanut Butter 1 serving from the drop down box, I want it to fill in the rest from the chart below.
Just a quick example... Thanks in advance for your help!
Qty | Calorie | Cal From Fat | Fat | Carbs | Fiber | Net Carbs | Protein | |
Peanut Butter 1 serving | ||||||||
Peanut Butter 2 servings | ||||||||
item | Qty | Calorie | cal from fat | fat | Carbs | Fiber | Net Carbs | Protein |
Peanut Butter 1 serving | 32g | 200 | 190 | 17 | 4 | 3 | 1 | 8 |
Peanut Butter 2 servings | 64g | 400 | 380 | 34 | 8 | 6 | 2 | 16 |
Butter 1 tbsp | 1 tbsp | 100 | 100 | 11 | 0 | 0 | 0 | 0 |
Butter 2 tbsp | 2 tbsp | 200 | 200 | 22 | 0 | 0 | 0 | 0 |