Issue with creating dependent dropdown list

[DarkSmile]

Hello,

I got an issue with a dependent dropdown list, for some reason it doesn't work.. If already created multiple successful dependent dropdown lists but for some reason this one won't work..
Is there some thing like text that blocks it?

Here what I got

copy.xlsx
	A	B	C
3	Parameters : ACS-038
4	Type activiteiten:	Feed/Food
5	Aantal Feed/Food activiteit:
6
7
8
9
10
11
12
13
14
15
16
17
18
19	Dropdown list: Type activiteiten	Placeholders
20	Feed/Food	Aantal Feed/Food activiteit:
21	Feed/Food & Landbouwproducten	Aantal Feed/Food & Landbouw activiteit:
22	Landbouwproducten	Aantal Landbouw activiteit:
23
24
25
26
27
28	Feed/Food	Feed/Food & Landbouwproducten	Landbouwproducten
29	<2	<2	1 Landbouw activiteit
30	2< - <5	2< - <5	2 Landbouw activiteit
31	5< - <10	5< - <10	3 Landbouw activiteit
32	>10	>10	Activiteit mengen in bulk
33		Feed/Food + 1 Landbouw activiteit	Invoer van organische meststoffen en/of groeimedia
34		Feed/Food + 2 Landbouw activiteit
35		Feed/Food + 3 Landbouw activiteit
36		Activiteit mengen in bulk
37		Invoer van organische meststoffen en/of groeimedia
ACS-038

Cell Formulas
Range	Formula
A5	A5	=IF(B4="Feed/Food",'ACS-038'!$B$20,IF(B4="Feed/Food & Landbouwproducten",'ACS-038'!$B$21,IF(B4="Landbouwproducten",'ACS-038'!$B$22,"N/A")))

Cells with Data Validation
Cell	Allow	Criteria
B4	List	=TypeActACS038
B5	List	=INDIRECT(B4)

File if prefered: Google Drive

 

[jasonb75]

I doubt that you have a range named Feed/Food in your sheet as / is not a valid character in a name.

 

[DarkSmile]

I doubt that you have a range named Feed/Food in your sheet as / is not a valid character in a name.

Range one where it says "Feed/Food" comes from A20:A22, the dependent list (that needs to come in B5) comes from A28:C37 but doesn't work

 

[jasonb75]

You can not name a range as Feed/Food

It is not a valid name, so it can not exist. If the name does not exist then there is nothing to show in the dropdown.

edit:- in the file that you attached, the range is named Food_Feed, not Food/Feed.

 

[DarkSmile]

You can not name a range as Feed/Food

It is not a valid name, so it can not exist. If the name does not exist then there is nothing to show in the dropdown.

edit:- in the file that you attached, the range is named Food_Feed, not Food/Feed.

Fixed it by renaming it as followed, thnx!

TCA berekening.xlsm
	A	B	C
3	Parameters : ACS-038
4	Type activiteiten:	Feed_Food
5	N/A
6
7
8
9
10
11
12
13
14
15
16
17
18
19	Dropdown list: Type activiteiten	Placeholders
20	Feed_Food	Aantal Feed/Food activiteit:
21	Feed_Food_Landbouwproducten	Aantal Feed/Food & Landbouw activiteit:
22	Landbouwproducten	Aantal Landbouw activiteit:
23
24
25
26
27
28	Feed_Food	Feed_Food_Landbouwproducten	Landbouwproducten
29	<2	<2	1 Landbouw activiteit
30	2< - <5	2< - <5	2 Landbouw activiteit
31	5< - <10	5< - <10	3 Landbouw activiteit
32	>10	>10	Activiteit mengen in bulk
33		Feed/Food + 1 Landbouw activiteit	Invoer van organische meststoffen en/of groeimedia
34		Feed/Food + 2 Landbouw activiteit
35		Feed/Food + 3 Landbouw activiteit
36		Activiteit mengen in bulk
37		Invoer van organische meststoffen en/of groeimedia
ACS-038

Cell Formulas
Range	Formula
A5	A5	=IF(B4="Feed/Food",'ACS-038'!$B$20,IF(B4="Feed/Food & Landbouwproducten",'ACS-038'!$B$21,IF(B4="Landbouwproducten",'ACS-038'!$B$22,"N/A")))

Cells with Data Validation
Cell	Allow	Criteria
B4	List	=TypeActACS038
B5	List	=INDIRECT(B4)

 

[jasonb75]

Happy to help

For future reference, I believe that you can only use letters, numbers, dot / period or underscore in a range name, no other characters are valid. If you try to enter an invalid name in the name manager then it will warn you of the problem.

From personal experience, the names that are automatically generated based on cell content will have any invalid characters replaced with underscores by default, it looks to me as if this is what has happened to you.