Forum Discussion

Luc_de_Jong's avatar
Luc_de_Jong
Copper Contributor
May 25, 2020

A question about dropdown lists

I have a question about dropdown lists. I want to make 3 dropdown lists (the last one dependent). Cell A12 and B12 are both drop down lists (not dependent). In the drop down list I have the opt...
excel
peteryac60's avatar
peteryac60
Iron Contributor
May 26, 2020

Luc_de_Jong 

 

Hi Luc

 

I attached an alternative solution.

 

This relies on setting up NAMES (see Formulas->Name Manager) for each group e.g. "HamstringBalance"  to cover those exercises; "HamstringStrength" for those exercises and so on.

 

The dependent drop down then using the Indirect function and the options you select in the first two column to point to the correct list of exercises.

 

Hope this helps.

 

Peter

 

 

Resources