HELP_DEPENDENT DROP-DOWN LISTS

Hi everyone !

Here is my dependent drop-down lists PROBLEM:

- I have 4 LEVELS (3e, 4e, 5e, 6e) in DATA VALIDATION

- Each LEVEL has 6 CLASSES (A, B, C, D, E, F) example: 3eA, 3eB, 3eC, 3eD, 3eE, 3eF)

So 24 CLASSES

I want once I select a LEVEL in (J2) from its drop-down lists I can also choose its CLASSES in (J3)

Example: for (J3) DATA VALIDATION be =(IF (J2)= "Class_3e") so (J3) = 3eA;3eB;3eC;3eD;3eE;3eF

               for (J3) DATA VALIDATION be =(IF (J2)= "Class_4e") so (J3) = 4eA;4eB;4eC;4eD;4eE;4eF

               for (J3) DATA VALIDATION be =(IF (J2)= "Class_5e") so (J3) = 5eA;5eB;5eC;5eD;5eE;5eF

               for (J3) DATA VALIDATION be =(IF (J2)= "Class_6e") so (J3) = 6eA;6eB;6eC;6eD;6eE;6eF

So that Each (J3) choosen CLASS fills "CLASS LIST" table (with yellow color)

File below:

MJrv4dnUZjI_HELP-DEPENDENT-DROP-DOWN-LISTS.xlsx

Thanks !!!