Dependent Dropdown list

[tonii4516]

https://drive.google.com/open?id=1z7JllULnypzq2qdpSXaUZqJhjQjuobXdiVCzOE1vsjY

Hello,

I'm trying to make a dependent dropdown list in the "Model" section B1, in A1 a drop down has been created and I defined a name on the Formulas tab, create from selection tab.

On the data validation, I am inputing as a list the formula =INDIRECT(B2). Receiving an error message "A source currently values to an error".

I would appreciate a little bit of help. I check some videos on how to do this and it seems I done everything correct so I don't know why I am getting this error message.

Thank you,

E.A.

 

[DanteAmor]

The names must be created without spaces, you can use the "_", for example, for "Daikin Applied" the name is created as "Daikin_Applied".
In the formula you replace the " " (space) with the "_"

The formula on data validation:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]=INDIRECT(SUBSTITUTE($A2," ","_"))[/TD]
[/TR]
</tbody>[/TABLE]


You can see 2 examples in the file:

https://www.dropbox.com/s/bcg83tnskhmcxvd/Dependent dropdown list dam.xlsx?dl=0

Check and tell me

 

[tonii4516]

I got it working. Thank you for pointing out I was missing the substitution for "_".

I appreciate your time.

E.A.

 

[DanteAmor]

I'm glad to help you