+ Reply to Thread
Results 1 to 2 of 2

Data Validation with Multiple Conditions

  1. 10-30-2014, 02:55 PM #1
    danhobbs55
    danhobbs55 is offline
    Registered User
    Join Date
    10-27-2014
    Location
    Indianapolis, IN
    MS-Off Ver
    2013
    Posts
    1

    Data Validation with Multiple Conditions

    Hi Guys!

    I'm pretty stuck on this one.

    I'm working in a shared workbook, so I cant manipulate the data validation settings in VBA. That would be too easy!

    I need to apply the data validation to the third column in the first image below. It will do a vlookup using the value in the first column ("Beam Wing Wicker" or "Ballast-Bulkhead" in this screenshot), looking at the range in the second image. If it finds that there's a value in the second column (it will in the case of "Beam Wing Wicker") then the data validation will be restricted to Range("Q:Q"). If it finds a blank (it will in the case of "Ballast - Bulkhead") then the data validation is any value. Basically what I'm saying is that there are only a few options for what could be listed next to "Beam Wing Wicker", but any value can be allowed next to "Ballast - Bulkhead".
    Untitled2.jpg

    Untitled.jpg

    I'm really stumped on how to accomplish this without manipulating the data validation settings, which isn't allowed in a shared workbook. Any help you guys would provide would be greatly appreciated!

    Thanks,

    Dan
    Reply With QuoteRegister To Reply
  2. 10-31-2014, 11:54 AM #2
    Pauleyb
    Pauleyb is offline
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Data Validation with Multiple Conditions

    Highlight the cells in your 'None' column. Use Data Validation and a formula similar to this:
    =IF(VLOOKUP(A1,$A$6:$B$8,2,0)="",TRUE,NOT(ISERROR(MATCH(C1,Q:Q,0))))

    In my case, A1 was the first element in your top table. A6:B8 is the bottom table. C1 is the first element in the third column of you top table (where 'None' is). Adjust as necessary.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Drop Down Data Validation - Display a result based on multiple conditions
    By carlmf1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:50 PM
  2. [SOLVED] Data Validation - Restrict cell with multiple conditions
    By hitarov in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-11-2013, 03:59 PM
  3. Data Validation with 2 conditions
    By gilbert in forum Excel General
    Replies: 3
    Last Post: 06-11-2011, 10:36 AM
  4. Multiple Conditions on Data Validation
    By kauelima in forum Excel General
    Replies: 3
    Last Post: 03-03-2011, 08:37 AM
  5. Data validation with conditions
    By mingali in forum Excel General
    Replies: 1
    Last Post: 08-07-2010, 02:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1