Trancetopia
New Member
- Joined
- Apr 13, 2015
- Messages
- 1
I hope someone can help with this. I have two sheets, sheet1 has a list of meals for each day of the week, the example below shows just meal 1 for Monday column C is for the food weight in grams, D is for Protein, E for carbs and F for fat. Sheet2 contains a list of food items that will match what the mail items will be in sheet1 but the food macros based on per 100 grams.
SHEET 1
<tbody>
</tbody>
SHEET 2
<tbody>
</tbody>
What I want to be able to do is when I click a button, each meal item in sheet1 needs to be checked for in sheet2, if food item names match, it will update sheet 1 Protein, Carb and Fat values based on a calculation of weight. So for example if Banana in sheet 1 has a match is Sheet 2, col D E F in sheet 1 will be updated based on the weight so in the banana example it nutrient values would be half the 100g values in sheet 2.
Hope this makes sense.
I'd attach the spreadsheet but I can't see any attach options.
SHEET 1
A | B | C | D | E | F | |
1 | Monday | g | P | C | F | |
2 | Shoulders | |||||
3 | Breakfast | Whey Protein (1.5 Scoops) | 40 | |||
4 | Oats | 50 | ||||
5 | Banana | 50 | .55 | 11.5 | .15 | |
6 | 1 Teaspoon Almond Butter | 5 | ||||
7 | ||||||
8 |
<tbody>
</tbody>
SHEET 2
A | B | C | D | |
1 | Food Item | Protein | Carbs | Fat |
2 | Whey Protein | |||
3 | Oats | |||
4 | Banana | 1.1 | 23 | 0.3 |
5 | Almond Butter | |||
6 | Chicken Breast |
<tbody>
</tbody>
What I want to be able to do is when I click a button, each meal item in sheet1 needs to be checked for in sheet2, if food item names match, it will update sheet 1 Protein, Carb and Fat values based on a calculation of weight. So for example if Banana in sheet 1 has a match is Sheet 2, col D E F in sheet 1 will be updated based on the weight so in the banana example it nutrient values would be half the 100g values in sheet 2.
Hope this makes sense.
I'd attach the spreadsheet but I can't see any attach options.
Last edited: