Hi all,
I am relatively new to Excel and am having difficulty achieving a dependent drop down. I have the basics all sorted but i cant seem to have a dependant drop down with a two word name? Is there anyone who could give any advice?
Thanks in advance.
Here, look this link:
http://www.contextures.com/xlDataVal02.html
You might also post your workbook so we can take a look.
When using a "two-word name" as reference to named range you will need to use the SUBSTITUTE function to replace the space character with an underscore. This is required because when creating a named range use of space character is not permitted.
If your "two word name" is "My List", your named range should be "My_List".
Then the Data Valiation source would be a formula like so:
=INDIRECT(SUBSTITUTE($A$1," ","_"))
Another useful link on the topic: Dependent Validation. Excel Data Validation List Based on the Value of Another
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks