+ Reply to Thread
Results 1 to 3 of 3

If statement based data validation? Dynamic data validation?

  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    North Myrtle Beach
    MS-Off Ver
    365 Business
    Posts
    82

    If statement based data validation? Dynamic data validation?

    I am working on a file that has three groups of 10 numbers each and three groups of 10 descriptions to go along with each of those numbers. I am planning on making a drop down validation (using a named range) for cell "B15" to contain the 30 numbers. Ideally, depending on which number they picked a specific validation drop down group of descriptions would then populate cell "D15". Group 1 of the numbers all start with "112##", group 2 starts with "113##" and group 3 starts with "114##" with the "#" being variable. If the user selects a number that starts with "112##", I need a specific 10 item validation drop down list to then populate in cell D15. If the user selects a number that starts with "113##" a different set of 10 item validation would populate, and so on for selecting numbers that start with "114##".

    Truncated Example:

    Group 1 #'s_________________Group 1 Descrips
    11200_______________________PL Modeling
    11210______________________ Shop Drawings
    11220 ______________________PL Risers
    11230______________________ PL Pre-Fab

    Group 2 #'s________________Group 2 Descrips
    11300______________________PP Modeling
    11310______________________PP Shop Drawings
    11320______________________PP Risers
    11330______________________PP Pre-Fab

    Group 3 #'s______________________Group 3 Descrips
    11400______________________SM Modeling
    11410______________________SM Shop Drawings
    11420______________________SM Risers
    11430______________________SM Pre-Fab

    User selects 11220 in cell B15, Cell D15 then offers a drop down including the "PL" description options

    Been working on this for two full days now and am totally confused
    Any help would be appreciated!
    Last edited by bjohnsonac; 10-02-2014 at 01:16 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: If statement based data validation? Dynamic data validation?

    Sounds like you need a dependent dropdown list. See link below.

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

  3. #3
    Registered User
    Join Date
    09-26-2008
    Location
    North Myrtle Beach
    MS-Off Ver
    365 Business
    Posts
    82

    Re: If statement based data validation? Dynamic data validation?

    Thank you for your reply. I already know how to do traditional dependent drop downs, its the complexity of this situation that is keeping me from being able to create them.. I was hoping not to have to create 30 different INDIRECT data validations. Since it is basically "If any of the numbers from group 1 of 10 numbers is selected, then give a list of these 10 descriptions....OR, if any of the numbers from group 2 of 10 numbers, then give list of 2nd 10 descriptions, etc. Using the INDIRECT route for validation is very cumbersome for this application.

    Maybe I have been looking at it for too long and am over-complicating it

+ 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. [SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 09:08 AM
  2. [SOLVED] Create Dynamic Data Validation List based upon Criteria
    By stubbsj in forum Excel General
    Replies: 6
    Last Post: 06-04-2012, 08:33 AM
  3. If Statement with data validation based on a letter
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2011, 11:23 AM
  4. Dynamic Range based on Data Validation
    By Dial1 in forum Excel General
    Replies: 3
    Last Post: 01-15-2010, 01:25 PM
  5. Dynamic Data Validation based on series in a single cell
    By ExcelLefty in forum Excel General
    Replies: 4
    Last Post: 09-29-2009, 08:45 AM

Tags for this Thread

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