What IF statements.

[fishcakes]

Not to sure if this the IF statement formula should be used or not, however this is what I am trying to solve...

B2: Cost drop down selections/options are either Y or N.
Based up on what is selected in B2, I would like to have the following drop/selections in B3:
If B2 = Y, then B3 dropdown selctions/options are either 'Monthly' or 'Annually'.
If B2 = N, then B3 dropdown selection is 'N'

 

[rlv01]

Not really sure what you are after

Book1
	A	B	C	D	E	F	G
1						B2 List	B3 List
2	Cost	Y				Y	Monthly
3	Type	Monthly				N	Annually
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IF($B$2="N","N","Monthly")
G3	G3	=IF($B$2="N","N","Annually")

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$F$2:$F$3
B3	List	=$G$2:$G$3

 

[fishcakes]

I think I may have worded the incorrectly

rlv01, let me try that again...​

 

[rlv01]

Book1
	A	B	C	D	E	F
1						B3 List
2	Cost	Y				Monthly
3	Type	Monthly				Annually
Sheet1

Cell Formulas
Range	Formula
F2	F2	=IF($B$2="N","NA","Monthly")
F3	F3	=IF($B$2="N","NA","Annually")

Cells with Data Validation
Cell	Allow	Criteria
B2	List	Y,N
B3	List	=$F$2:$F$3

 

[fishcakes]

Almost, I have reworded what I need...

 

[kevin9999]

Does something like this work for you? I would also have a worksheet change event to empty cell B3 whenever there's a change in B2.

Book1
	A	B	C	D	E
1
2	COST	Y		annual	N/A
3	Type			Monthly
4
5
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B2	List	Y,N
B3	List	=IF(B2="Y",$D$2:$D$3,$E$2)

Worksheet change code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("B2"), Target) Is Nothing Then
        Application.EnableEvents = False
        [B3].Select: [B3] = ""
        Application.EnableEvents = True
    End If
End Sub

 

[fishcakes]

Yes it does! Excellent, thankyou

kevin9999​

and

rlv01​

 

[kevin9999]

Glad we could help & thanks for the feedback