Dependant dropdown error

[Aussiebear]

I was experimenting with dependant dropdowns using the indirect command within data validation when I found that on a Mac it works for a second dropdown but not the third one. What have I done wrong?

[arnelgp]

the third dropbox Named Range coincide with Ordinary Cell address, so it is in conflict.
see the "new" data validation source of combo3.

[Aussiebear]

Yes you were right. I have deleted all the named ranges, created new data, name ranges and bingo, there she blows

[Paul_Hossler]

Well, FWIW I'm not sure that was the original problem (I'm on Win 10)

I think there was some inconsistency between the Names and the DV values

1. Many Names had _ suffix but the DV pick list did not

29982

2. You were missing the INDIRECT() I think

29981


3. "Sun Valley" in E13 text had no _, but Name does


29983


4. List of Names

29984

[Aussiebear]

Thank you Paul. Yes I also noticed that in Name Manager. Some of the named Ranges had the _ symbol at the end of the names so I simply deleted those and reconfigured the named range. And Yes I also screwed up the Indirect() within Data Validation. I was on this sort of logical roundabout that I couldn't get off. Maybe If I had simply walked away, cleared my mind and then come back to the issue I probably would have found it. I had a one way ticket to "Frustration Central"

[Paul_Hossler]

Even less obvious was the underscore between Sun_Valley in Names, but not in the data

BTW, I do like the use of INDIRECT() that way. Never would have thought of that, but should be useful

[Aussiebear]

I found an example of indirect() on a internet search