+ Reply to Thread
Results 1 to 10 of 10

data validation--multiple dependent list

  1. #1
    Michael
    Guest

    data validation--multiple dependent list

    Hi all,

    Does anyone know how to create two list in different cells based on the
    selection of the first list?

    For example, i have one drop down list with these items: A, B ,C, D.

    If 'A' is chosen, then i have two seperate cells that are dependent on the
    selection of 'A' with their own list of values. 'A' has values of "A1, A2."

    And 'A1' has list of 1,2,3,4
    'A2' has list of 5,6,7,8.


    I hope someone can help. Thanks in advance.

  2. #2
    Dave Peterson
    Guest

    Re: data validation--multiple dependent list

    Debra Dalgleish knows how:
    http://contextures.com/xlDataVal02.html

    Michael wrote:
    >
    > Hi all,
    >
    > Does anyone know how to create two list in different cells based on the
    > selection of the first list?
    >
    > For example, i have one drop down list with these items: A, B ,C, D.
    >
    > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    >
    > And 'A1' has list of 1,2,3,4
    > 'A2' has list of 5,6,7,8.
    >
    > I hope someone can help. Thanks in advance.


    --

    Dave Peterson

  3. #3
    Michael
    Guest

    Re: data validation--multiple dependent list

    Hey Dave,

    Thanks for your reply. I have already looked at that particular example
    posted on the website. However, it does not say anything about muliple lists
    that depends on the first selection. The examples on the website talks
    mainly about just one list dependent on the first choice, using the indirect
    function in data validation.

    I have two different cells that are dependent on what is selected in the
    first cell...I hope i am being clear.

    "Dave Peterson" wrote:

    > Debra Dalgleish knows how:
    > http://contextures.com/xlDataVal02.html
    >
    > Michael wrote:
    > >
    > > Hi all,
    > >
    > > Does anyone know how to create two list in different cells based on the
    > > selection of the first list?
    > >
    > > For example, i have one drop down list with these items: A, B ,C, D.
    > >
    > > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    > >
    > > And 'A1' has list of 1,2,3,4
    > > 'A2' has list of 5,6,7,8.
    > >
    > > I hope someone can help. Thanks in advance.

    >
    > --
    >
    > Dave Peterson
    >


  4. #4
    Dave Peterson
    Guest

    Re: data validation--multiple dependent list

    Do the first cell following Debra's instructions.

    Then do the second cell following the same instructions.

    I don't understand why that wouldn't work.

    Michael wrote:
    >
    > Hey Dave,
    >
    > Thanks for your reply. I have already looked at that particular example
    > posted on the website. However, it does not say anything about muliple lists
    > that depends on the first selection. The examples on the website talks
    > mainly about just one list dependent on the first choice, using the indirect
    > function in data validation.
    >
    > I have two different cells that are dependent on what is selected in the
    > first cell...I hope i am being clear.
    >
    > "Dave Peterson" wrote:
    >
    > > Debra Dalgleish knows how:
    > > http://contextures.com/xlDataVal02.html
    > >
    > > Michael wrote:
    > > >
    > > > Hi all,
    > > >
    > > > Does anyone know how to create two list in different cells based on the
    > > > selection of the first list?
    > > >
    > > > For example, i have one drop down list with these items: A, B ,C, D.
    > > >
    > > > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > > > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    > > >
    > > > And 'A1' has list of 1,2,3,4
    > > > 'A2' has list of 5,6,7,8.
    > > >
    > > > I hope someone can help. Thanks in advance.

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

  5. #5
    Peo Sjoblom
    Guest

    Re: data validation--multiple dependent list

    I believe Debra posted a sample file recently for a casino in Vegas where
    there are multiple
    lists for croupiers to avoid them pushing the wheel on the same roulette
    table <vbg>, it's on her download page


    Peo


    "Dave Peterson" <[email protected]> wrote in message
    news:[email protected]...
    > Do the first cell following Debra's instructions.
    >
    > Then do the second cell following the same instructions.
    >
    > I don't understand why that wouldn't work.
    >
    > Michael wrote:
    >>
    >> Hey Dave,
    >>
    >> Thanks for your reply. I have already looked at that particular example
    >> posted on the website. However, it does not say anything about muliple
    >> lists
    >> that depends on the first selection. The examples on the website talks
    >> mainly about just one list dependent on the first choice, using the
    >> indirect
    >> function in data validation.
    >>
    >> I have two different cells that are dependent on what is selected in the
    >> first cell...I hope i am being clear.
    >>
    >> "Dave Peterson" wrote:
    >>
    >> > Debra Dalgleish knows how:
    >> > http://contextures.com/xlDataVal02.html
    >> >
    >> > Michael wrote:
    >> > >
    >> > > Hi all,
    >> > >
    >> > > Does anyone know how to create two list in different cells based on
    >> > > the
    >> > > selection of the first list?
    >> > >
    >> > > For example, i have one drop down list with these items: A, B ,C, D.
    >> > >
    >> > > If 'A' is chosen, then i have two seperate cells that are dependent
    >> > > on the
    >> > > selection of 'A' with their own list of values. 'A' has values of
    >> > > "A1, A2."
    >> > >
    >> > > And 'A1' has list of 1,2,3,4
    >> > > 'A2' has list of 5,6,7,8.
    >> > >
    >> > > I hope someone can help. Thanks in advance.
    >> >
    >> > --
    >> >
    >> > Dave Peterson
    >> >

    >
    > --
    >
    > Dave Peterson




  6. #6
    Michael
    Guest

    Re: data validation--multiple dependent list

    Dave,

    Thanks again for your reply.

    Will you give me an example? I don't think you can use the same name for
    two different lists. This is the reason i think it wouldn't work.

    Appreciate your help.

    "Dave Peterson" wrote:

    > Do the first cell following Debra's instructions.
    >
    > Then do the second cell following the same instructions.
    >
    > I don't understand why that wouldn't work.
    >
    > Michael wrote:
    > >
    > > Hey Dave,
    > >
    > > Thanks for your reply. I have already looked at that particular example
    > > posted on the website. However, it does not say anything about muliple lists
    > > that depends on the first selection. The examples on the website talks
    > > mainly about just one list dependent on the first choice, using the indirect
    > > function in data validation.
    > >
    > > I have two different cells that are dependent on what is selected in the
    > > first cell...I hope i am being clear.
    > >
    > > "Dave Peterson" wrote:
    > >
    > > > Debra Dalgleish knows how:
    > > > http://contextures.com/xlDataVal02.html
    > > >
    > > > Michael wrote:
    > > > >
    > > > > Hi all,
    > > > >
    > > > > Does anyone know how to create two list in different cells based on the
    > > > > selection of the first list?
    > > > >
    > > > > For example, i have one drop down list with these items: A, B ,C, D.
    > > > >
    > > > > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > > > > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    > > > >
    > > > > And 'A1' has list of 1,2,3,4
    > > > > 'A2' has list of 5,6,7,8.
    > > > >
    > > > > I hope someone can help. Thanks in advance.
    > > >
    > > > --
    > > >
    > > > Dave Peterson
    > > >

    >
    > --
    >
    > Dave Peterson
    >


  7. #7
    Michael
    Guest

    Re: data validation--multiple dependent list

    Hi Peo,

    Do you have a link? Thanks for your help.

    "Peo Sjoblom" wrote:

    > I believe Debra posted a sample file recently for a casino in Vegas where
    > there are multiple
    > lists for croupiers to avoid them pushing the wheel on the same roulette
    > table <vbg>, it's on her download page
    >
    >
    > Peo
    >
    >
    > "Dave Peterson" <[email protected]> wrote in message
    > news:[email protected]...
    > > Do the first cell following Debra's instructions.
    > >
    > > Then do the second cell following the same instructions.
    > >
    > > I don't understand why that wouldn't work.
    > >
    > > Michael wrote:
    > >>
    > >> Hey Dave,
    > >>
    > >> Thanks for your reply. I have already looked at that particular example
    > >> posted on the website. However, it does not say anything about muliple
    > >> lists
    > >> that depends on the first selection. The examples on the website talks
    > >> mainly about just one list dependent on the first choice, using the
    > >> indirect
    > >> function in data validation.
    > >>
    > >> I have two different cells that are dependent on what is selected in the
    > >> first cell...I hope i am being clear.
    > >>
    > >> "Dave Peterson" wrote:
    > >>
    > >> > Debra Dalgleish knows how:
    > >> > http://contextures.com/xlDataVal02.html
    > >> >
    > >> > Michael wrote:
    > >> > >
    > >> > > Hi all,
    > >> > >
    > >> > > Does anyone know how to create two list in different cells based on
    > >> > > the
    > >> > > selection of the first list?
    > >> > >
    > >> > > For example, i have one drop down list with these items: A, B ,C, D.
    > >> > >
    > >> > > If 'A' is chosen, then i have two seperate cells that are dependent
    > >> > > on the
    > >> > > selection of 'A' with their own list of values. 'A' has values of
    > >> > > "A1, A2."
    > >> > >
    > >> > > And 'A1' has list of 1,2,3,4
    > >> > > 'A2' has list of 5,6,7,8.
    > >> > >
    > >> > > I hope someone can help. Thanks in advance.
    > >> >
    > >> > --
    > >> >
    > >> > Dave Peterson
    > >> >

    > >
    > > --
    > >
    > > Dave Peterson

    >
    >
    >


  8. #8
    Michael
    Guest

    Re: data validation--multiple dependent list

    Dave,

    Here is another example. I hope this is clearer.

    ie. cell A1 has a data validation list of silver,gold,red,blue.

    If cell A1 is "silver", I want an INDIRECT data validation list with
    1,2,3,4,5 in cell B1

    If cell A1 is "silver", I want an INDIRECT data validation with
    Mats,Owen,Joe,Alex,Ed in C1.


    "Michael" wrote:

    > Dave,
    >
    > Thanks again for your reply.
    >
    > Will you give me an example? I don't think you can use the same name for
    > two different lists. This is the reason i think it wouldn't work.
    >
    > Appreciate your help.
    >
    > "Dave Peterson" wrote:
    >
    > > Do the first cell following Debra's instructions.
    > >
    > > Then do the second cell following the same instructions.
    > >
    > > I don't understand why that wouldn't work.
    > >
    > > Michael wrote:
    > > >
    > > > Hey Dave,
    > > >
    > > > Thanks for your reply. I have already looked at that particular example
    > > > posted on the website. However, it does not say anything about muliple lists
    > > > that depends on the first selection. The examples on the website talks
    > > > mainly about just one list dependent on the first choice, using the indirect
    > > > function in data validation.
    > > >
    > > > I have two different cells that are dependent on what is selected in the
    > > > first cell...I hope i am being clear.
    > > >
    > > > "Dave Peterson" wrote:
    > > >
    > > > > Debra Dalgleish knows how:
    > > > > http://contextures.com/xlDataVal02.html
    > > > >
    > > > > Michael wrote:
    > > > > >
    > > > > > Hi all,
    > > > > >
    > > > > > Does anyone know how to create two list in different cells based on the
    > > > > > selection of the first list?
    > > > > >
    > > > > > For example, i have one drop down list with these items: A, B ,C, D.
    > > > > >
    > > > > > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > > > > > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    > > > > >
    > > > > > And 'A1' has list of 1,2,3,4
    > > > > > 'A2' has list of 5,6,7,8.
    > > > > >
    > > > > > I hope someone can help. Thanks in advance.
    > > > >
    > > > > --
    > > > >
    > > > > Dave Peterson
    > > > >

    > >
    > > --
    > >
    > > Dave Peterson
    > >


  9. #9
    Peo Sjoblom
    Guest

    Re: data validation--multiple dependent list

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

    the top one


    Peo


    "Michael" <[email protected]> wrote in message
    news:[email protected]...
    > Hi Peo,
    >
    > Do you have a link? Thanks for your help.
    >
    > "Peo Sjoblom" wrote:
    >
    >> I believe Debra posted a sample file recently for a casino in Vegas where
    >> there are multiple
    >> lists for croupiers to avoid them pushing the wheel on the same roulette
    >> table <vbg>, it's on her download page
    >>
    >>
    >> Peo
    >>
    >>
    >> "Dave Peterson" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Do the first cell following Debra's instructions.
    >> >
    >> > Then do the second cell following the same instructions.
    >> >
    >> > I don't understand why that wouldn't work.
    >> >
    >> > Michael wrote:
    >> >>
    >> >> Hey Dave,
    >> >>
    >> >> Thanks for your reply. I have already looked at that particular
    >> >> example
    >> >> posted on the website. However, it does not say anything about
    >> >> muliple
    >> >> lists
    >> >> that depends on the first selection. The examples on the website
    >> >> talks
    >> >> mainly about just one list dependent on the first choice, using the
    >> >> indirect
    >> >> function in data validation.
    >> >>
    >> >> I have two different cells that are dependent on what is selected in
    >> >> the
    >> >> first cell...I hope i am being clear.
    >> >>
    >> >> "Dave Peterson" wrote:
    >> >>
    >> >> > Debra Dalgleish knows how:
    >> >> > http://contextures.com/xlDataVal02.html
    >> >> >
    >> >> > Michael wrote:
    >> >> > >
    >> >> > > Hi all,
    >> >> > >
    >> >> > > Does anyone know how to create two list in different cells based
    >> >> > > on
    >> >> > > the
    >> >> > > selection of the first list?
    >> >> > >
    >> >> > > For example, i have one drop down list with these items: A, B ,C,
    >> >> > > D.
    >> >> > >
    >> >> > > If 'A' is chosen, then i have two seperate cells that are
    >> >> > > dependent
    >> >> > > on the
    >> >> > > selection of 'A' with their own list of values. 'A' has values of
    >> >> > > "A1, A2."
    >> >> > >
    >> >> > > And 'A1' has list of 1,2,3,4
    >> >> > > 'A2' has list of 5,6,7,8.
    >> >> > >
    >> >> > > I hope someone can help. Thanks in advance.
    >> >> >
    >> >> > --
    >> >> >
    >> >> > Dave Peterson
    >> >> >
    >> >
    >> > --
    >> >
    >> > Dave Peterson

    >>
    >>
    >>




  10. #10
    Dave Peterson
    Guest

    Re: data validation--multiple dependent list

    I created a list and named it Colors.

    I used that for my data|validation list for A1.

    I created a list called "Silver_Numbers" (1,2,3,4,5)
    and used this for the Data|Validation list in B1:
    =INDIRECT(A1&"_Numbers")

    I created a list called "Silver_Names" (mats, owen, ..., Ed)
    and used this for the Data|Validation list in c1:
    =INDIRECT(A1&"_Names")

    Each of these cells (B1 and C1) are only dependent on the value in A1.




    Michael wrote:
    >
    > Dave,
    >
    > Here is another example. I hope this is clearer.
    >
    > ie. cell A1 has a data validation list of silver,gold,red,blue.
    >
    > If cell A1 is "silver", I want an INDIRECT data validation list with
    > 1,2,3,4,5 in cell B1
    >
    > If cell A1 is "silver", I want an INDIRECT data validation with
    > Mats,Owen,Joe,Alex,Ed in C1.
    >
    > "Michael" wrote:
    >
    > > Dave,
    > >
    > > Thanks again for your reply.
    > >
    > > Will you give me an example? I don't think you can use the same name for
    > > two different lists. This is the reason i think it wouldn't work.
    > >
    > > Appreciate your help.
    > >
    > > "Dave Peterson" wrote:
    > >
    > > > Do the first cell following Debra's instructions.
    > > >
    > > > Then do the second cell following the same instructions.
    > > >
    > > > I don't understand why that wouldn't work.
    > > >
    > > > Michael wrote:
    > > > >
    > > > > Hey Dave,
    > > > >
    > > > > Thanks for your reply. I have already looked at that particular example
    > > > > posted on the website. However, it does not say anything about muliple lists
    > > > > that depends on the first selection. The examples on the website talks
    > > > > mainly about just one list dependent on the first choice, using the indirect
    > > > > function in data validation.
    > > > >
    > > > > I have two different cells that are dependent on what is selected in the
    > > > > first cell...I hope i am being clear.
    > > > >
    > > > > "Dave Peterson" wrote:
    > > > >
    > > > > > Debra Dalgleish knows how:
    > > > > > http://contextures.com/xlDataVal02.html
    > > > > >
    > > > > > Michael wrote:
    > > > > > >
    > > > > > > Hi all,
    > > > > > >
    > > > > > > Does anyone know how to create two list in different cells based on the
    > > > > > > selection of the first list?
    > > > > > >
    > > > > > > For example, i have one drop down list with these items: A, B ,C, D.
    > > > > > >
    > > > > > > If 'A' is chosen, then i have two seperate cells that are dependent on the
    > > > > > > selection of 'A' with their own list of values. 'A' has values of "A1, A2."
    > > > > > >
    > > > > > > And 'A1' has list of 1,2,3,4
    > > > > > > 'A2' has list of 5,6,7,8.
    > > > > > >
    > > > > > > I hope someone can help. Thanks in advance.
    > > > > >
    > > > > > --
    > > > > >
    > > > > > Dave Peterson
    > > > > >
    > > >
    > > > --
    > > >
    > > > Dave Peterson
    > > >


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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