How to have conditional dropdown

R

Ramki

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
 
Top