• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Validating a list’s value based on what is selected in another list [SOLVED]

LeonK

New Member
Hello all, I hope you can help me? I want to validate a list entry which was originally selected from a list based on a previous list selection. Chandoo's blog on the subject was great for creating a multi list solution;


http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/


I now need a way of knowing if the sub lsit selection is valid when the main list selection is changed. In so doing, users will see if they have correctly selected on a dashboard. I am thinking that a conditional format is the solution but cannot seem to put the formula together to achieve this.


The logic is something like:


If selection B is in group A then do nothing, else highlight entry as invalid


I appreciate any assistance on this. Many thanks


Regards


LeonK
 
Good day LeonK


I think you may be talking about dependant data validation! Try this link


http://www.contextures.com/xlDataVal02.html
 
bobhc - I like this version from Deb's site, because it uses non-volatile functions:

http://www.contextures.com/xlDataVal15.html


ALso I think that LeonK is talking more about highlighting 'downstream' choices if upstream choices change. e.g. if you first select vegetables from picklist 1, then choose broccoli from picklist two, then go back and change your initial choice to 'Fruit' then my code clears the 'broccoli' entry.


Here's a file of mine that does just that:

https://www.dropbox.com/s/ueqf2ewc6a3rx4y/Dynamic%20Dependent%20dropdowns%2020130628.xlsm
 
Bob. Thanks for the excellent link to Debra's site - Now bookmarked.


Jeffrey, your solution is perfect and so much more than I wanting to achieve. I especially like the fact that your code deletes invalid entries once 'upstream' choices are changed. Thanks also for providing a descriptive way for articulating the process; up and down streams.


Kind regards - LeonK
 
Back
Top