P pulkit476 New Member Dec 3, 2012 #1 hello friends I have a situation here cell A1 i will have values Yes, No or NA and cell A2 the condition in A2 if A1=NA then the cell value should be NA (without drop down)else it should give me a drop down option of Yes, No I hope i am able to make sense. BR's Pulkit
hello friends I have a situation here cell A1 i will have values Yes, No or NA and cell A2 the condition in A2 if A1=NA then the cell value should be NA (without drop down)else it should give me a drop down option of Yes, No I hope i am able to make sense. BR's Pulkit
bobhc Excel Ninja Dec 3, 2012 #2 Good day Pulkit476 You may find this link of help http://www.contextures.com/xlDataVal02.html