Dependent dropdownlist error

[istanto]

Dear All,

First of all I want to say hello everybody, my name Istanto . Currently I 'm starting to learn to deepen the use of MS Excel application to support the activities of my daily work.
But I have a problem related to the use of " Dependent Dropdown list" , which I created dropdownlist with the data validation method (indirect function) with the list name.
But when I make a define name is numeric ( eg 07 ) dependent dropdownlist can not work and appear popups ... .

data vaildation.pngpopup error.png
Dependent dropdownlist - belajarexcel.info.xlsx

Where cell M6 should contain the list : ME , IE , BG , IT , AD , PL , EN , DC , TC , WS
How do to fix for above case?

Best Regards,
Istanto

[FDibbins]

Hi, welcome to the forum

1st, I suggest you remove all those spaces in middle of your data (or use them all oover
2nd I used this for the DV rule...
=INDIRECT("_"&$J$6)
Note that your range name starts with an underscore _ so your DV must return that

[NeedForExcel]

That maybe because, when you create a name with a name like 07, it gets stored as _07..

Press Ctrl+F3 and observe your defined name.. You might get the issue

[bebo021999]

DataValidation treats M6="ME , IE , BG , IT , AD , PL , EN , DC , TC , WS" as one item in list

The Solution should be:

M6="ME"
M7="IE"
...
M15="WS"

then use the range M6:M15 as Source for DataValidation

[istanto]

Hi @FDibbins, that's awesome ...., GREAAAAT!
Thanks very much. It's work perfectly as I need.

[FDibbins]

Happy to help, thanks for the feedback