Wondering if the experts can help me out with the following questions


Cell C8 has drop down where I can select the options from 1 to 20.
Based on the above selection I need to have another drop down in cell D8
If the valve selected in C8 is between 1 and 10, I can select a,b,c,d,e,f but if the valve selected is between 10 and 20 I can only select option e and f.


Any help or guidance would be appreciated.