+ Reply to Thread
Results 1 to 4 of 4

conditional data validation

  1. #1
    Registered User
    Join Date
    10-25-2009
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    3

    conditional data validation

    I have 2 data validation listboxes
    I want the 2nd listbox to be populated with certain values conditional upon user's choice in the 1st listbox.

    i.e., if i choose x in the 1st listbox, then there are certain values in the
    2nd listbox, if i choose y in the 1st listbox, then there are different values in the 2nd listbox

    I know I can do this with naming ranges of cells, and the function INDIRECT
    My problem is that I can’t name a range of cells with a numeric value and this is required in my case.

    This what I’m trying to do:
    A1 has 3 options (listbox)– 0,1,H
    B1 depends on AI:
    If A1 = 0, then B1 has 3 options - A,B,C
    if A1 = 1, then B1 has 3 options - D,E,F
    If A1 = H then B1 has 3 options – G,H,I

    Any ideas?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,025

    Re: conditional data validation

    Try look in here:

    http://www.contextures.com/xlDataVal02.html
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    10-25-2009
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: conditional data validation

    thanks so much!
    works like a charm...

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,025

    Re: conditional data validation

    Please make thread [solved] (Go to first post -> Edit -> Go advanced -> choose solved from drop down menu)

+ 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