Forum Discussion
Boulakgnobot
Oct 17, 2023Brass Contributor
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,...
Riny_van_Eekelen
Oct 18, 2023Platinum Contributor
Boulakgnobot Changed the names for the list ranges so that you can use =INDIRECT(J2) in cell J3. See attached.
Saw in your file that you have some more questions but I didn't understand your intention there. Please clarify.
Boulakgnobot
Oct 18, 2023Brass Contributor
Thanks for your help ! It's EXACTLY what I WANTED for the first point !
I'm not an expert and I don't know how you named (J2) to make it changed through the column
3eA 4eA 5eA
3eB 4eB 5eB
3eC 4eC 5eC
Because I don't see anywhere the names for the list ranges (not in the NAME BOX and not in the NAME MANAGER)
HOW do you do it so that I can redo it ???
CAN you EXPLAIN this more ???
I'm not an expert and I don't know how you named (J2) to make it changed through the column
3eA 4eA 5eA
3eB 4eB 5eB
3eC 4eC 5eC
Because I don't see anywhere the names for the list ranges (not in the NAME BOX and not in the NAME MANAGER)
HOW do you do it so that I can redo it ???
CAN you EXPLAIN this more ???
- Riny_van_EekelenOct 18, 2023Platinum Contributor
Boulakgnobot Not sure where you are looking. I'm on a Mac right now but it's similar on a PC.
In the name box, I see this:
and in the name manager I see this:
Don't you see the same?
- BoulakgnobotOct 18, 2023Brass Contributor
I did ! What I don't understand is "=indirect(L2)" in DATA VALIDATION
- Riny_van_EekelenOct 19, 2023Platinum Contributor
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.