Magnatolia
Board Regular
- Joined
- Jan 19, 2012
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm having a mental blank. I have created a very simple food tracker that I can vlookup the nutrition details from a sheet that has the USDA export of all this information.
My end result is a few manual columns including date, food item, grams, and then a vlookup for each nutrient. There's about 50 nutrients.
I set up my vlookup and added date to the rows. I then added the first nutrient to the value and it summed perfectly. But if I do that I'll have no headings, so I added the same field to the column area and get each value as a column heading.
How can I do it so I can say on the 3rd MArch I consumed 50g protein, 20g carbs, etc?
Thanks!
I'm having a mental blank. I have created a very simple food tracker that I can vlookup the nutrition details from a sheet that has the USDA export of all this information.
My end result is a few manual columns including date, food item, grams, and then a vlookup for each nutrient. There's about 50 nutrients.
I set up my vlookup and added date to the rows. I then added the first nutrient to the value and it summed perfectly. But if I do that I'll have no headings, so I added the same field to the column area and get each value as a column heading.
How can I do it so I can say on the 3rd MArch I consumed 50g protein, 20g carbs, etc?
Thanks!
