dependent, multiple variable, drop down list

Discussion in 'Excel Beginners' started by narcosmurf, Sep 25, 2013.

  1. narcosmurf

    narcosmurf Guest

    I am trying to setup a form that has several drop-down lists that updat
    the subsequent drop down until a final result is listed.

    To simplify it, I'll narrow this down, but the final build will have 1
    options in first column, second would have 80 options per 1 option i
    first column, then about 10 in third per option in column 2, etc... S
    I couldn't do this with a simple IF statement.

    Below is a simplified listing of information. If someone could send m
    in the right direction, where to look or what to look up, I would b
    appreciative. Searching for information on the web withou
    understanding all the formulas for excel is next to impossible.

    First drop down would list:
    A
    B
    C

    A is chosen, second drop down would list:
    1
    2
    3

    B is chosen, second drop down would list:
    4
    5
    6

    C is chosen, second drop down would list:
    7
    8



    --
    narcosmurf
     
    narcosmurf, Sep 25, 2013
    #1
    1. Advertisements

  2. narcosmurf

    narcosmurf Guest

    Delete this thread, found the answer in another thread once I poste
    this


    --
    narcosmurf
     
    narcosmurf, Sep 25, 2013
    #2
    1. Advertisements

  3. narcosmurf

    Claus Busch Guest

    Hi,

    Am Wed, 25 Sep 2013 02:13:58 +0100 schrieb narcosmurf:

    > To simplify it, I'll narrow this down, but the final build will have 15
    > options in first column, second would have 80 options per 1 option in
    > first column, then about 10 in third per option in column 2, etc... So
    > I couldn't do this with a simple IF statement.


    have a look:
    http://www.contextures.com/xlDataVal13.html
    http://www.contextures.com/xlDataVal02.html
    http://www.contextures.com/xlDataVal15.html


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Sep 25, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Tan
    Replies:
    1
    Views:
    150
  2. Gupta
    Replies:
    1
    Views:
    163
    Roger Govier
    Oct 5, 2005
  3. snarled times

    CREATE MULTIPLE DROP DOWN LIST IN SAME WORKBOOK?

    snarled times, Feb 19, 2006, in forum: Excel Beginners
    Replies:
    2
    Views:
    110
    Peo Sjoblom
    Feb 19, 2006
  4. Energy
    Replies:
    2
    Views:
    80
    dpatte601
    May 10, 2006
  5. Colder
    Replies:
    4
    Views:
    125
    Debra Dalgleish
    Aug 25, 2006
  6. CompeterN
    Replies:
    1
    Views:
    111
    Don Guillett
    Nov 8, 2006
  7. SSJ

    DEPENDENT DROP DOWN LIST

    SSJ, Mar 24, 2008, in forum: Excel Beginners
    Replies:
    1
    Views:
    79
    Debra Dalgleish
    Mar 24, 2008
  8. Pepper

    Dependent Drop-Downs (Contextures web site)

    Pepper, Oct 3, 2008, in forum: Excel Beginners
    Replies:
    3
    Views:
    116
    Pepper
    Oct 4, 2008
Loading...