I want to set up a spreadsheet to track my calories.
Screenshot (305).png
I was wondering if I could tie the 500 to the eggs and 600 to the oatmeal. More specifically I want to know if its possible for the calories to autofill when I select an item from the dropdown list. For example if I only eat eggs then when I select eggs in the drop down menu I want 500 to display in the calories. If I were to select oatmeal as a second food item then I'd like 1100 to autofill in the calories box. Is this possible using excel? Thanks!
Bookmarks