Drop-down list to appear if a condition is met

[Bering]

hello,

I have a drop-down list in cell B3 with 4 items (Monthly, Quarterly, Semi-annual, Annual).

I would like to have a drop-down list appearing in cell C3 (with 2 items, Group1, Group2) only if the value of B3 is Quarterly. This means that if, for example, the value in B3 is Monthly, then the list in C3 should vanish and the cell should be blank. Is that possible?

My attempts so far:

1. I created a named range for cells F3 and F4 which I called Selection. In "refers to" I inserted the formula: =if(B3="Quarterly",F3:F4)

2. In cell C3 I created a drop-down list which has as source my named range, Selection.


The drop-down list works fine if quarterly is selected, however the first item of the selection (Group1) still appears when the other 3 items are selected.

Many thanks for any suggestion.

 

[snekkman]

Hi,

I have done something similar with IF an INDIRECT withinthe datavalidation:

=IF(D19="4340",INDIRECT("'Data fra visma'!UTSTYR_GH"),IF(OR(D19="4320",D19="4330"),INDIRECT("'Data fra visma'!PERSONELL_GH"),INDIRECT("'Data fra visma'!tom")))

Last range is empty.

Eirik.

 

[Bering]

Thanks Eirik, I wil give this a try