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:
<tbody>
</tbody>
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:
<tbody>
</tbody>
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.
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:
| Food (1 serv) | Carbs (g) | Fat (g) | Protein (g) |
| Cheese | 4 | 10 | 10 |
| Strawberries | 20 | 0 | 1 |
| Almonds | 4 | 10 | 6 |
| Vanilla | 0 | 0 | 0 |
| Sugar | 30 | 0 | 0 |
<tbody>
</tbody>
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:
| Food 1 | Food 2 | |||
| Food | (Dropdown) | Food | (Dropdown) | |
| Carbs (g) | x | Carbs (g) | x | |
| Fat (g) | x | Fat (g) | x | |
| Protein (g) | x | Protein (g) | x |
<tbody>
</tbody>
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.
