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.

[TABLE="width: 248"]
<tbody>[TR]
[TD][/TD]
[TD]B2[/TD]
[TD]B3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Capability[/TD]
[TD]Yes/No[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Voice[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Voice Skills Based Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]IVR[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]IVR Call Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]IVR Skills Based routing[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]Automated Surveys[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]Surveys (IVR)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]Surveys (Web/email/text)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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:
=IF( A2="Yes", drop down list,IF(A2="No", "", IF(A2="N/A", "","")))

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...tatement-contains-data-validation-option.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).