Dropdown menus based on other cells value

[Little_Ghost]

Hi All,

I have a problem which I can't get solved.
Column C and D are should be picked from a dropdown list (data is in named range on sheet 3).
The choices that have t become available in a dropdown list in column E (values also in named rnage on sheet 3) should be based on the combination of column C and D.
The choices that have t become available in a dropdown list in column H (values also in named rnage on sheet 3) should be based on the value of column C.

I'm not sure the way it is set up now (as far as it is setup) is the way to go.
Here is a link to the file, I hope this is clear :S
https://www.dropbox.com/s/1cg78f31zmjpoag/opzetje_1.xlsx

Hope someone can help me.

Kind regards.

 

[Little_Ghost]

Noticed the link was not working. Here is a new one.
https://dl.dropboxusercontent.com/u/38821746/opzetje_1.xlsx