Using a dropdown to fill in multiple cells

[Tyvent]

Greetings,

I'm self-taught in Excel. Unfortunately, that may be why I'm not well-versed in Excel jargon, and that's probably why I'm having such a hard time looking up the information that I need.

Cutting to the chase, I need to create a dropdown list that, depending on the item selected, will fill in different values in multiple cells. I know how to create a basic dropdown list. I suspect the multiple value list should look something like this (the values listed are off the top of my head and probably inaccurate, but that's not important here) where the first column will have the dropdown items and the others will have the values to automatically input into other cells:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Food (1 serv)[/TD]
[TD]Carbs (g)[/TD]
[TD]Fat (g)[/TD]
[TD]Protein (g)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cheese[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Strawberries[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Almonds[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Vanilla[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Sugar[/TD]
[TD]30[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

Yes, I have a cheesecake craving. Anyway, the sheet where I will select the dropdown and need the automatic input of the associated values looks something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Food 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Food 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Food[/TD]
[TD](Dropdown)[/TD]
[TD][/TD]
[TD]Food[/TD]
[TD](Dropdown)[/TD]
[/TR]
[TR]
[TD]Carbs (g)[/TD]
[TD]x[/TD]
[TD][/TD]
[TD]Carbs (g)[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Fat (g)[/TD]
[TD]x[/TD]
[TD][/TD]
[TD]Fat (g)[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Protein (g)[/TD]
[TD]x[/TD]
[TD][/TD]
[TD]Protein (g)[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]

Again, I can create the basic dropdown. I need to find out what I need to do to automatically fill in the Carbs, Fat, and Protein values with, say, 4 10 and 10 respectively when I select Cheese from the dropdown.

Thank you for your time, folks.

 

[Tyvent]

I'll give that a shot after dinner and let you guys know what happens if you need that info to help me further.

Worst case scenario, I can just throw the data table on the same sheet and hide the cells I guess.

I FINALLY got the formula to work! I kept referring to the wrong cells when adapting the formula you provided to my purposes. Now it's perfect. Thanks!

I'm still going to give the language input a try. Back with the results.