Selection from cell with list contents autopopulates contents of another cell

[markharper80]

Good day all,


This is my first post so let me start by saying thank you in advance. I will do my best to make sense describing the challenge I am facing in Excel...

I am creating a grocery shopping planner for our office. I have sheet 1, cell a1 as a list type (which i have done through the data validation > list )and the data in that list are meals (hot dogs, sandwiches, etc). The list items referenced in sheet 1, a1 are on sheet 2 cells b2 through b10. (so sheet 2, b2 would be hot dogs, b3 would be sandwiches and so forth). In sheet 2 column C, I will list the ingredients. So if sheet 2, b2 is hot dog, then sheet 2 C3 would be 'buns, franks, etc' .

What I would like to have happen is when the user selects a meal in sheet 1 from the list in A1 (which is pulled from sheet 2 , items b2-b10), then the ingredients list (sheet 2 c2-c10) that corresponds to items b2-b10 in sheet 2 will populate to another column on sheet 1.

So user selects a meal from the list and the ingredients populate for them somewhere else on the page. Its been a while since I have utilized excel at legth so I am a bit rusty here. Any help is appreciated. Thanks!