+ Reply to Thread
Results 1 to 4 of 4

Combining a custom data validation and a list validation

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Combining a custom data validation and a list validation

    Need some help with combining a custom data validation and a list validation in the same cell.

    Information in cell B2 can't be entered until cell A2 is entered. This continues thru cell F2. I am using this formula:

    Please Login or Register  to view this content.
    Information in G2 can't be entered until F2 is entered and the input can only be Yes or No. I tried this formula in G2, but only half of it worked:

    Please Login or Register  to view this content.
    Information in H2 can't be entered until G2 is entered and the input can only be 1,2,3,4,Safe or HR.

    I have attached what I am working on.

    Thanks for helping.
    Attached Files Attached Files
    Last edited by jmcole; 07-13-2023 at 03:49 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Combining a custom data validation and a list validation

    The strategy is to create your lists on another sheet. One of those lists is just a blank cell. Then have an IF condition to determine whether your dropdown displays the blank cell or the desired list. See attached. I just did G & H in row 2, you can fill down.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: Combining a custom data validation and a list validation

    Quote Originally Posted by 6StringJazzer View Post
    The strategy is to create your lists on another sheet. One of those lists is just a blank cell. Then have an IF condition to determine whether your dropdown displays the blank cell or the desired list. See attached. I just did G & H in row 2, you can fill down.
    Thank You Sir.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Combining a custom data validation and a list validation

    My pleasure and thanks for the rep!

+ 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 (drop down list) - combining 'IF' with 'AND'
    By nosense in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-10-2015, 05:17 AM
  2. merge list validation and custom validation
    By fjober in forum Excel General
    Replies: 2
    Last Post: 11-18-2014, 03:36 PM
  3. Combining a data validation list with a custom formula (including error message)
    By robgron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 07:23 AM
  4. Replies: 9
    Last Post: 04-16-2014, 09:55 AM
  5. Combining If statement and data validation (non-list)
    By zangana in forum Excel General
    Replies: 0
    Last Post: 08-07-2012, 07:54 AM
  6. How to incorporate validation list in custom validation?
    By ohlalayeah in forum Excel General
    Replies: 11
    Last Post: 08-07-2012, 06:01 AM
  7. Data Validation (Combining custom text and named range)
    By stuart010 in forum Excel General
    Replies: 1
    Last Post: 12-13-2011, 06:59 AM

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