How do I create an IF Statement that contains a data validation option

[jkitterm]

I am filling out a list of capabilities that have sub-capabilities.
A2 is the Capabilty Name
A3 is the Sub-Capability name
B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A"
In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a drop down list (Yes, No, or N/A)to select from for B3 or if it is not Yes then leave the cell blank.
A B
1 Capability Yes/No
2 Voice Yes
3 Voice Skills Based Routing Yes
4 IVR No
5 IVR Call Routing
6 IVR Skills Based routing
7 Automated Surveys Yes
8 Surveys (IVR) Yes
9 Surveys (Web/email/text) No



I would think the IF statement would look something like this but I am not sure what the syntax is to have it present a drop down list:
(In B3 Cell) =IF( B2="Yes", drop down list,"")
(In B5 and B6 Cells =IF( B4="Yes", drop down list,"")

PLEASE NO VB CODE OR MACROS

[José Augusto]

Try this
In E2:E5 put the following validation list: "Yes", "No", "N/A", #empty cell

In B2:B3 use the following validation list =IF($B$2="Yes", $E$2:$E$5, $E$5)

see the file

[jkitterm]

Works like a charm!

Thanks!

[José Augusto]

You are welcome.

Please, do not forget to mark this thread as SOLVED.