How to have conditional dropdown
 

I have various drop-down values which I have named them. Based on a value in
a different cell, I need to have dynamic drop-down values.

For e.g.

If cell A1 has "A", I should have dropdown values in B1 as "A1, A2, A3
....etc."
else
If cell A1 has "B", I should have dropdown values in B1 as "B1, B2, B3
....etc."

Need help in how to use the IF condition in the Data Validation menu in excel.

Thanks and Regards

How to have conditional dropdown
 

Hi

take a look here
http://www.contextures.com/xlDataVal02.html

--
Regards
Roger Govier

"Ramki" wrote in message
...
I have various drop-down values which I have named them. Based on a value
in
a different cell, I need to have dynamic drop-down values.

For e.g.

If cell A1 has "A", I should have dropdown values in B1 as "A1, A2, A3
...etc."
else
If cell A1 has "B", I should have dropdown values in B1 as "B1, B2, B3
...etc."

Need help in how to use the IF condition in the Data Validation menu in
excel.

Thanks and Regards