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?
Printable View
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?
the third dropbox Named Range coincide with Ordinary Cell address, so it is in conflict.
see the "new" data validation source of combo3.
Yes you were right. I have deleted all the named ranges, created new data, name ranges and bingo, there she blows
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
Attachment 29982
2. You were missing the INDIRECT() I think
Attachment 29981
3. "Sun Valley" in E13 text had no _, but Name does
Attachment 29983
4. List of Names
Attachment 29984
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"
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
I found an example of indirect() on a internet search