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.

	B2	B3
A1	Capability	Yes/No
A2	Voice	Yes
A3	Voice Skills Based Routing	Yes
A4	IVR	Yes
A5	IVR Call Routing	Yes
A6	IVR Skills Based routing	No
A7	Automated Surveys	No
A8	Surveys (IVR)
A9	Surveys (Web/email/text)

<tbody>
</tbody>

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).