Illegal Characters in Drop downs

[ERed1]

Hey everyone,

Does anyone know how to use illegal characters in a Drop down? I have looked it up, but everything I have read went over my head. I have a a drop down that is dependent on a drop down. In the first drop down I have a few fractions that need to be options. Thanks for the help.

 

[Aryatect]

Can you please share a screenshot of the Name Manager from Formula tab so that I can see the exact name of the list.

 

[ERed1]

It is asking me to have a url to post a screenshot of my name manager. So I will type it out. I just tried mimicing the data you made so I could figure it out.
Name Value
_1_2 {"1";"2";"3"}
_1_4 {"x";"y";"z"}
A {1/2}
B {1/8}
C_ {1/4}

 

[Aryatect]

Hi, So here is what I had done I put the data in the sheet as shown below:

Book1
	J	K	L	M	N	O	P	Q	R	S	T
1	First	Second	Third		A	B		1/2	1/4	1/8	3/8
2	B	1/8	Orange		1/2	1/8		1	X	Apple	House
3	A	1/2	2		1/4	3/8		2	Y	Orange	Car
4	A	1/4	X					3	Z
Sheet1

Defined name as shown in the attached:
https://drive.google.com/open?id=17CY8Og3mRi6wNC6fJ42s4LPNav9Qskzl

Data Validation for Column K:
https://drive.google.com/open?id=1MtGVJvcWG0B1aMOnPW_drDP_So58ztUi

Data Validation for Column L:
https://drive.google.com/open?id=15k_Qvjh-HltWD7vUi0FgDEQIaSni5Ves

Point to note here is that i stored 1/4, 1/8 etc as text.

 

[ERed1]

Thank you so much for clearing that up. I got it to work with your previous post!

 

[Aryatect]

Glad could help and thanks for the feedback!