Hi Experts,

This is my first post and before posting, I have searched the whole forum for this issue.

The issue is as follows:

Suppose A2 cell has value as "Yes" or "yes".
So if A2 = "Yes" then
B2 will have a drop down list of "Yes" and "No", so that user can select yes or no from the Drop-down list.
But if the A2 cell has any values other than Yes/yes then
B2 will show "N/A"

Current workaround is:
B2=IF(OR(A2="Yes",A2="yes"),"Yes","N/A")
Please help regarding the issue.

Regards,
Sap.