I need 5 drop down lists.
Lists 2 through 5 are all dependent on list one.
I can get the drop down of list 1 and 2 but cannot get lists 3 - 5 to be dependent on list 1
Any thoughts?
Thanks!
I need 5 drop down lists.
Lists 2 through 5 are all dependent on list one.
I can get the drop down of list 1 and 2 but cannot get lists 3 - 5 to be dependent on list 1
Any thoughts?
Thanks!
Actually I learnt something new today about INDIRECT and I might have the solution for you. I did not know that it could be used this way in a validation formula.
I could figure out the problem that you had. The INDIRECT was pointing to the same sheet System in all columns.
Here is a fix.
Step1
Create unique names for each of the Validation value sets
Like for example - System Sheet> Hospital (B4:B16) should be named with a prefix "Sys" to be named "Sys_Hospital"
similarly in the Event sheet "Eve_Hospital"
and so on and so forth
Step2
Modify your validation formula - Instead of =INDIRECT($D3), for SYSTEM column use the formula = INDIRECT("Sys_"&$D3) and for EVENT Column use the formula =INDIRECT("Eve_"&$D3)
I learnt something new today.
Thanks and Take care
Worked beautifuly!
Thanks!
@ruthl Welcome to the forum.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.
Also as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks