Multiple/Dependent Dropdowns

[rbobcat1]

Is there a way to have multiple but specific dropdowns?

Column A has a series of letters A-Z for one dropdown.

Column B has a series of numbers for a dropdown.

Col A Col B
A 1.1, 1.2, 1.3, 1.4 Choices
B 2.1, 2.2, 2.3, 2.4 Choices
C 3.1, 3.2, 3.3, 3.4 Choices

So in Col A if I select A then Col B will only allow me to choose 1.1, 1.2, 1.3, 1.4

 

[Luke M]

Several articles have been written on dependent data validation.
You could start here:
http://www.contextures.com/xlDataVal02.html
or here:
http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/

 

[rbobcat1]

That works, guess i should have search Chandoo's a little deeper...
Thx