+ Reply to Thread
Results 1 to 2 of 2

if statement wtih data validation

Hybrid View

  1. 07-21-2016, 11:43 AM #1
    matty0511
    matty0511 is offline
    Registered User
    Join Date
    01-30-2013
    Location
    isentcom emperor
    MS-Off Ver
    Excel 2013
    Posts
    25

    if statement wtih data validation

    Lets say I have two validation lists. What I want is if I select a specific item only then show a different validation list in the adjacent column.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-21-2016, 11:47 AM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: if statement wtih data validation

    It seems like you are wanting Dependent data validation.
    http://excelsemipro.com/2011/05/a-dy...list-in-excel/
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a 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. If statement based data validation? Dynamic data validation?
    By bjohnsonac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2014, 02:12 PM
  2. [SOLVED] IF statement on data Validation
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 04:17 AM
  3. Using existing open Internet Explorer to post data from excel to the website wtih VBA
    By cfernand74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 11:19 AM
  4. Data validation and If statement
    By tjohans in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2013, 05:20 PM
  5. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  6. I need my drop down arrow to continuously appear wtih a data validation list
    By dlefever in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2011, 02:24 PM
  7. Data validation in if statement
    By mahoo in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1