Link to Excel file: Diet (1).xlsx
I have a diet planner that I am trying to work with.
FOOD CATALOG sheet has all the macro information.
MEAL BUILDER sheet has the DATE, TIME, FOOD (from drop-down), and GRAMS eaten.
-Issue one: VLOOKUP is failing for random things. In the link, "Baby Potatoes" isn't being found in the FOOD CATALOG sheet, but it works if I just call it "Potatoes".
DAILY DIET sheet should add all info from the MEAL BUILDER sheet that has a matching date.
-Issue two: I've tried SUM with VLOOKUP and SUMIFS, but I haven't been able to get it to show more than one cell of data.
Any help is greatly appreciated!
I have a diet planner that I am trying to work with.
FOOD CATALOG sheet has all the macro information.
MEAL BUILDER sheet has the DATE, TIME, FOOD (from drop-down), and GRAMS eaten.
-Issue one: VLOOKUP is failing for random things. In the link, "Baby Potatoes" isn't being found in the FOOD CATALOG sheet, but it works if I just call it "Potatoes".
DAILY DIET sheet should add all info from the MEAL BUILDER sheet that has a matching date.
-Issue two: I've tried SUM with VLOOKUP and SUMIFS, but I haven't been able to get it to show more than one cell of data.
Any help is greatly appreciated!