Forum Discussion
TomS1995
Dec 12, 2023Copper Contributor
Multiple data entry from drop down list
Hi all,
I’m trying to create a diet tracker that allows me to be able to match a number to a specific meal and the calories etc attached to that meal.
The general idea is a list of meals numbered 1-99 with the dietary information. Next to this a table with breakfast, lunch, dinner and snacks slots next to a daily total for calories, protein, carbs and fats.
For example - If you were to select no.1 in the breakfast column then I want it to populate the daily total for each area in the correct column.
Any help with either linking multiple values to the initial drop down number selection or with how to get the totals to show in the other table would be amazing.
Thanks in advance,
Tom
=SUM(MMULT(TRANSPOSE(N($B$4:$B$13=$I4:$M4)),E$4:E$13))
You can apply this formula. The formula is in cell O4 and filled across range O4:Q13. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
- OliverScheurichGold Contributor
=SUM(MMULT(TRANSPOSE(N($B$4:$B$13=$I4:$M4)),E$4:E$13))
You can apply this formula. The formula is in cell O4 and filled across range O4:Q13. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
- TomS1995Copper ContributorYoure a wizard! Thank-you!!