Drop Down menu

[jawadbaksh]

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.

[DBY]

Hello welcome to the forum.

You can use a formula in the drop down list, for example:

Please Login or Register  to view this content.

Here there are two Named Ranges: 'List1' is the first list, 'a' through to 'f' and 'List2', 'e' and 'f'.

Hope this helps.
DBY

[jawadbaksh]

Thanks Buddy that works

[DBY]

Glad to have helped.