Excel - Dependent Drop Down Lists

[Justin]

Argh! This is doing my head in today, should be straight forward

I am creating a spreadsheet to track designers commissions. First column is the designers name, easy enough as a drop list. Then, the next section needs to show that particular designers work so I can track which design has sold. So, another drop down but this time it has to be dependant upon the name of the designer I choose.

I found several tutorials, followed through no problem but when I try to work with my own data something is going wrong.





These are 2 tutorials which I'm following. Issue I have is when I define the =INDIRECT list. Always comes up with an error.

Could anyone show me a quick sheet where this works please? Or maybe tell me where I'm going wrong.

vB_ID:5695

Excel-Drop-Down-List-Conditional-Indirect.jpg (15.08 KiB) Viewed 18 times

[webtrekker]

I'm no Excel expert, but reading through the linked articles do any of your named ranges include spaces? They should be underscores, ie. John Smith should be John_Smith. Apparently spaces aren't allowed in named ranges.

Don't know if that's of any help at all!

[Skye]

Hi Justin,
Had a quick look at the second tutorial & have it working. That's quite a useful tool.
Just wondering if you have the "ranges" set up correctly. Look in Name Manager (Formulas -> Name manager) - is the data right?

I expect your data is confidential, but if you want to DM a trial spreadsheet, I can look at it for you.
Skye

[Justin]

I'm no Excel expert, but reading through the linked articles do any of your named ranges include spaces? They should be underscores, ie. John Smith should be John_Smith. Apparently spaces aren't allowed in named ranges.)

No, I noticed that so avoided spaces

[Justin]

Hi Justin,
Had a quick look at the second tutorial & have it working. That's quite a useful tool.
Just wondering if you have the "ranges" set up correctly. Look in Name Manager (Formulas -> Name manager) - is the data right?

I expect your data is confidential, but if you want to DM a trial spreadsheet, I can look at it for you.
Skye

Thanks Skye Nah, nothing particularity confidential, just a list of names and designs really. I'm just playing to try and get it working with basic info before I populate.

It's something silly I'm doing wrong, I can get a list of fruit and veg working no problem! Hahaha.

[Skye]

Thanks Justin.

Free feel to DM it later, if it doesn't work out.

Skye

[Justin]

Many thanks for the input, after thinking I'd checked it was indeed just the space underscore issue! GGGRRR!

[Skye]

Justin,
Good to hear you've sorted it out.
Skye