First Time creating Dependent drop downs need help

jaspers87

New Member
Joined
Nov 23, 2016
Messages
9
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

Capture_zpsgovdaex7.jpg
[/URL][/IMG]
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Capture_zpsgovdaex7.jpg
[/URL][/IMG]

Sorry this didn't come through on the previous post. This is what my spreadsheet looks like
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,089
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top