Need help making a formula for a Calorie/macro Tracker (VLookup / Match /offset function)

[natenate88]

Hi all, trying to put together a calories and macro tracker. I've looked at other samples but can't seem to figure this out. I'm new to this and have just been doing process and error but I'm not getting anywhere.

Here my file on the link below, via another excel forum,

http://www.excelforum.com/attachments/excel-general/372097d1421905268-making-a-calorie-and-macros-tracker-need-help-with-vlookup-and-match-functions-calorietracker.xlsx

I've got my first sheet where I would enter my foods from dropdowns, and the values would automatically fill in. I made a "Categories" column with a dropdown list to differentiate the food items. So if I chose the Dairy/Milk in the dropdown the next column over would correspond with the list of Dairy and milk items.

My next sheet is where I made the database, organized by the categories. Then I just have a list of my categories on the last sheet.

Since I've listed my categories in one table, I would need a function to sort out the items in the list that correspond to the category?
Meaning if I chose "Dairy/Milk" in the DD, it would lookup and match "Dairy/Milk" from the database and list the corresponding food items in the DD. Please give me some input, thanks a lot.

Any advice or help to get this to work? Any help would be greatly appreciated.

Here my file on the link below, via another excel forum,

http://www.excelforum.com/attachments/excel-general/372097d1421905268-making-a-calorie-and-macros-tracker-need-help-with-vlookup-and-match-functions-calorietracker.xlsx

 

[natenate88]

anyone?

 

[Blade Hunter]

Out of curiosity, why are you building this? MyFitnessPal for your phone is free and already does calorie tracking and includes barcode scanning so it's quick and easy to add what you have eaten.

 

[natenate88]

I have my own specifications I wanted to make. Hopefully I can get this to work.