Lists - autopopulating fields based on what's chosen from list

[obiwanvaldez]

I hope I am asking this question correctly. I have a predefined list of foods that I am using for a nutrition workbook. On my source list I have a food then a qty, calorie, fat, protein carbs cells that are matched to whatever food they are next too. I have a total of 8 worksheets - Monday-Sunday and then the Foods list worksheet. On my days of the week worksheets it has the same columns - food, qty, calorie, fats, protein, carbs. My question is this - I am using the list for the column on foods. If I pick a food from the predefined list, for example a banana, can I have the other fields besides qty autopopulate? So if I pick banana can I have it's calories fat protein and carbs autofill? If so, how? I appreciate everyone's help!! Hopefully it made sense. Thanks again!!

 

[obiwanvaldez]

That worked! Thank you very much! Y'all have been a big help.

I guess the last thing I need to figure out is multiplying my quantity by the populated results. So if i eat 2 bananas, I would type 2 in my quantity column and my results would be reconfigured. I guess im just not sure where to stick that within the formula. I know it would be the Qty cell with *, but im not sure where to put it.

 

[obiwanvaldez]

You'll never believe this but I figured it out. Everything is set. Thanks so much for your assistance. I really appreciate it!!

 

[T. Valko]

You'll never believe this but I figured it out. Everything is set. Thanks so much for your assistance. I really appreciate it!!

Good deal. Thanks for the feedback!