+ Reply to Thread
Results 1 to 4 of 4

Creating a dependent output via a previous selection [Data validation lists]

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    9

    Creating a dependent output via a previous selection [Data validation lists]

    Hi, hoping for some help.

    I have two Data Validation lists. The first contains:
    None
    Web
    Inhouse

    the second contains:
    Yes
    No

    Is it possible for the second to auto populate to 'No' if they select 'None' from the first list? Thanks

  2. #2
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Creating a dependent output via a previous selection [Data validation lists]

    Have a look at this link, this should sort you out

    mhtml:http://officeimg.vo.msecnd.net/en-gb...F010285763.mht
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left

  3. #3
    Registered User
    Join Date
    10-05-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Creating a dependent output via a previous selection [Data validation lists]

    Thanks TheCman81. Yes I had seen this and it doesn't quite work. If the value is already set to Yes and then you change the first list value to None. The second list value will stay at Yes until you manually change it (the only option available to you then is No). I'm looking to auto populate the second list value.

  4. #4
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Creating a dependent output via a previous selection [Data validation lists]

    Is the second selection only ever going to be Yes or No?

    If so you can use a formula

    =IF(A1="None","No","Yes")

+ 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. Replies: 2
    Last Post: 09-07-2013, 03:55 AM
  2. Replies: 11
    Last Post: 07-05-2013, 03:19 AM
  3. Creating 4th, 5th.... dependent list (validation List)
    By Elainefish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2013, 04:51 PM
  4. Creating a Dependent Validation List
    By cpalmer72 in forum Excel General
    Replies: 5
    Last Post: 01-31-2013, 12:38 PM
  5. Creating a filtered validation list based on selection of another
    By dgtwitch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2010, 09:20 PM

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