I am trying to create a food log with a drop down menu. I want to be able to click on the food item in the drop down menu and have the numbers for calories, fat, carbohydrates, and protein automatically fill in for me. I understand that I will have to put all the info in somewhere else before hand to create the list w/ the numbers, but not sure where to do this. Thanks in advance for the help!!!!
Last edited by JoeHan; 11-29-2011 at 11:37 AM.
Try this example...
HTH
Regards, Jeff
Maybe something like this?
Do some reading on Data Validation Lists and VLOOKUP.
Data Validation List Links:
http://office.microsoft.com/en-us/ex...005202215.aspx
http://www.contextures.com/xldataval01.html
VLOOKUP Links:
http://www.techonthenet.com/excel/formulas/vlookup.php
http://office.microsoft.com/en-us/ex...005209335.aspx
http://www.timeatlas.com/5_minute_ti...ookup_in_excel
Thank u all so much!!!!!!
If you are satisfied with the solution(s) provided, please do not forget to mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks