+ Reply to Thread
Results 1 to 3 of 3

Using "if" and "validation" together - pick from one list, second list shows up

Hybrid View

taketwo Using "if" and "validation"... 08-27-2009, 10:22 AM
ChemistB Re: Using "if" and... 08-27-2009, 10:24 AM
taketwo Re: Using "if" and... 08-27-2009, 11:14 AM
  1. #1
    Registered User
    Join Date
    08-03-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2003
    Posts
    60

    Using "if" and "validation" together - pick from one list, second list shows up

    I was hoping that somebody could help me out on this.

    I would like to have a validation table that, when used, provides a second validation table based on the selection made in the first one.

    My company provides a wide array of services that I would like to divide into categories - the first drop-down would list these categories ("Cleaning", "Repair", etc.), and then have the next column's drop-down only show those services under the "Cleaning", "Repair", etc. categories.

    I know how to make validation tables (I have already created the different tables, with each service under its proper category), but I don't know to get Excel to make one list "pop up" after making a selection from another one.

    Thank you in advance.
    Last edited by taketwo; 08-27-2009 at 11:14 AM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Using "if" and "validation" together - pick from one list, second list shows up

    You'll need to put the second list in another cell using Data Validation and the INDIRECT function. See this link. http://www.contextures.com/xlDataVal02.html
    Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    08-03-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Using "if" and "validation" together - pick from one list, second list shows up

    That's exactly what I was looking for.

    Thanks a lot.

+ 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