DSF

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.

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!

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

webtrekker;137899 wrote: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

Skye;137900 wrote: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.

Thanks Justin.

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

Skye

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

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