Hello everyone,

I really need some help trying to complete this task. After trying and investigating all over I can't manage to figure this out. What I'm trying to achieve is to obtain a list of options in a drop down list based on another list shown in a drop down list.I have successfully done it with the first entry,but it is not possible to drag this set up to the remaining cells below because once you select the 2nd drop down list in the row beneath the first,the populate list corresponds to the the first row populated list.
I've been watching youtube videos about this matter,but no lucking undestanding how to do this.

Thank you for your time.


Please see attached file example