+ Reply to Thread
Results 1 to 4 of 4

Problem with second depended data validation list

  1. #1
    Registered User
    Join Date
    06-04-2015
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    2

    Problem with second depended data validation list

    Hi guys,

    I have an issue with second dependent data validation list.
    The thing is that I made a table with all tasks that are generated weekly. I have columns: "Task category", "Task", "Assigned to" and etc. Important are those first three. Also, I made dependence between first two columns with indirect formula in data validation, but I cannot find solution how to include dependence between first and third column, because I want to shorten list of all employees that I can assign to particular task category. I do not want option to select an employee who is not able to perform that task.

    I hope that I was clear. I would be grateful if you have any suggestions or solutions...

    Thanks...

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Problem with second depended data validation list

    Hi and welcome to the forum,

    I can do no better than point you to Debra's web site where you'll learn all you need to know about this subject.

    http://www.contextures.com/xlDataVal02.html
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Problem with second depended data validation list

    This small example might help you. It uses tables and names created from the tables.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    06-04-2015
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    2

    Re: Problem with second depended data validation list

    Thanks guys for your replies...
    The right solution I found on this thread
    I don't know how I missed it.
    Last edited by sajva; 06-08-2015 at 04:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data validation list problem
    By LyeS in forum Excel General
    Replies: 7
    Last Post: 07-07-2014, 04:20 PM
  2. Data Validation Problem with List
    By ofd2008 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2014, 11:53 AM
  3. [SOLVED] Data validation list problem
    By batador in forum Excel General
    Replies: 6
    Last Post: 08-24-2013, 06:48 PM
  4. DATEDIF Problem with Data Validation List
    By ReFFi in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-24-2010, 06:41 PM
  5. Problem using a data validation list in charting
    By kcstewart in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-21-2008, 02:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1