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