Create a validation list in E2 pending on D2

Hello,
I'm looking for help to lookup a value (D2) then list the sub -range in the validation (E2).
If I change the value in D2, the list in E2 will be automaticly update including the change
cell content.


I like if this can be done using function something liked array formular (I think). I like
have soultion for using VBA as well.


Thanks