Conditional Drop Down Based on Another Drop Down

[mattman123]

Hello,

I am dealing with two drop down lists and an inefficiency that I hope to clean up.

In the first drop down box I have data like this:

1,XXX
2,XXX
3,XXX
4,XXX

In the second column more data that looks like this:

1,XXX
1,YYY
1,ZZZ
2,XXX
2,YYY
2,ZZZ
3,XXX
3,YYY
3,ZZZ
4,XXX
4,YYY
4,ZZZ

When the analyst choose "1,XXX", for example, in the first drop down box, they should be restricted to just the data in the second drop down list that begins with the corresponding number. Sometimes, if the first drop down entry is "9,XXX", the analyst has to scroll through all the 1s, 2s, 3s and so on before they get to the data that corresponds.

Is there a way, when an analysts selects "1,XXX" that only the data that begins with "1" will appear in the second drop down box?

Thanks for your help,
Matt

[Pete_UK]

Debra Dalgleish shows how you can set up dependent data validation like this on her website:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete