Forum Discussion

awesomechair123's avatar
awesomechair123
Copper Contributor
Mar 22, 2023

Excel - choosing between different options

Hi

Im making an eatingplan in excel. the first section is Macros for different food types. The other sections are recipes (breakfast, lunch, diner). The problem is, that once i have inserted the types of food in my recipes, i have to use those ingredients. I would like to be able to choose between different options of foods. 

For Example: 

Here i have a recipe. If i have written the macroes for 12% chicken, it wouldnt know the recipe's macros if i for example used chicken with 8% fat.

This is the section Macros, where i enter macros for different foods. 

So Im hoping you could help me make it possible to choose between different food types in my recipes in the other sections, using the data for the Macros section. Im thinking a slide thing where i can click on an ingredient, a slide shows and then i can choose between other ingredients

Hope i have formulated it in a way you can understand and that you can help me 🙂

 

Resources