I'm trying to create dependent Drop down lists for the first time and I'm running stuck .
My Drop downs are as follows- Make , model , Hitch Type (UMS,Premier,SL), Box (short,reg,long) after this I need it to display a value in the next cell(not sure how this will work yet either ).
I have the make and model Drop downs working and im running into issues with hitch type. When I make my list titled "2017 Ford F250/350 “Super Duty” (6 ½’ & 8’ Boxes)" containing my 3 hitch types ( 8551009/8552031/8553017) it places underscores in place of the spaces, so my indirect function doesn't work.
I appreciate any input Thanks
[/URL][/IMG]
My Drop downs are as follows- Make , model , Hitch Type (UMS,Premier,SL), Box (short,reg,long) after this I need it to display a value in the next cell(not sure how this will work yet either ).
I have the make and model Drop downs working and im running into issues with hitch type. When I make my list titled "2017 Ford F250/350 “Super Duty” (6 ½’ & 8’ Boxes)" containing my 3 hitch types ( 8551009/8552031/8553017) it places underscores in place of the spaces, so my indirect function doesn't work.
I appreciate any input Thanks
