hallo, a little brainteaser for the weekend.

I've run in to this problem, it envoled limited choices.

Short discription:
Basically the content of the second list is alter by the choice made in the fist list.

Long discription:
In the first list there are 13 choices, the choices are: 1, 2, 3, 4, A, B, C, Aa, Ab, Ba, Bb, Ca and Cb.

Choices 1, 2, 3 and 4 are related to EN 10308 and EN 10228.
Choices A, B and C are related to SEP 1920
Choices Aa, Ab, Ba, Bb, Ca and Cb are related to SEP 1921

When I select A of Bb the field next to it shows SEP 1920 of SEP 1921, this is the easy part. But as you can see the numbers have two opties, there either related to EN 10308 or EN 10228. So when I select a number I need to have a second list, not showing me one result but both, and I want to select one of these choices.

I have inserted the excel model. limited choices.xls
I hope this is clear enough.

Best regards,
Werner Peerboom