Forum Discussion

Brass Contributor

Oct 17, 2023

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,...

Formulas and Functions

Boulakgnobot

Brass Contributor

Oct 18, 2023

I did ! What I don't understand is "=indirect(L2)" in DATA VALIDATION

Riny_van_Eekelen

Platinum Contributor

Oct 18, 2023

Boulakgnobot J2 contains the selected class by its name. Then, =INDIRECT(J2) points the validation list to the named range which name is in cell J2.

Boulakgnobot
Brass Contributor
Oct 19, 2023
NOW CAN you help with the POINT 2 ???

FILE above
https://www.cjoint.com/c/MJtwF6cLaXs
- Riny_van_Eekelen
  Platinum Contributor
  Oct 19, 2023
  Boulakgnobot I hope you are on Excel365 or 2021 as this is easy with the FILTER function. See attached.
  HELP-DEPENDENT-DROP-DOWN-LISTS.xlsx23 KB
  - Boulakgnobot
    Brass Contributor
    Oct 20, 2023
    Thanks ! I mistake with orientation ! Instead of "above" file it was "BELOW" NEW FILE with the PICTURE illustration
    
    I'm SORRY !
    
    YES I'm Excel 365
    
    https://www.cjoint.com/c/MJtwF6cLaXs
    
    PS: If you CAN HELP again
Boulakgnobot
Brass Contributor
Oct 19, 2023
THANKS ! THANKS ! Now I get it !