lock dropdown list to a dropdown value

[mathias74]

Hi Mr. Excel..

Im trying to figure out how to combine to dropdown lists, based on each others value.

Fx. I have two dropdown lists.
1) list of building components as door, window, wall etc.
2) SfB numbers as 31, 32, 33 etc.

I want list 2, with the numbers, to change when I choose ie. door. So when i choose door in cell a1, b1 will auto fill out with the number 31.

I hope you can help.
Thanks, Mathias

 

[VoG]

Hi. Try this http://www.contextures.com/xlDataVal02.html