+ Reply to Thread
Results 1 to 3 of 3

Dependent Dropdown Data Validation

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    5

    Dependent Dropdown Data Validation

    I have data setup (shown in image)
    excel test.png

    The main idea here is to pick two answers from a drop down and depending on what is chosen a value or values will show in another dropdown. The issue here is this formula does not fit into the data validation list space provided. I can't point the validaion list to a cell because a simple cell cant handle multple answers. In this case only peach and grape will show in the cell because it has only 1 item associated with it.

    Please Login or Register  to view this content.
    Is there a way to shorten this formula or another way to achieve the desired result?

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Dependent Dropdown Data Validation

    You've posted this question here twice, and also on other online forums. Please read this http://www.excelguru.ca/content.php?184

  3. #3
    Registered User
    Join Date
    08-30-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    5

    Re: Dependent Dropdown Data Validation

    This question is different the other one i posted. This post its checking different data lists depending on output of one specific cell and then checking for a match and generating a drop down with multiple answers. The other question i posted checks 1 data list as all columns as a whole represent a specific answer and returns that one specific answer not a drop down.

+ 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] Dependent dropdown data validation
    By ArnolddG in forum Excel General
    Replies: 3
    Last Post: 07-03-2014, 03:31 PM
  2. [SOLVED] Dependent Dropdown Validation Lists
    By Root River Hardwoods in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 05:30 PM
  3. [SOLVED] VBA data validation, dependent dropdown list
    By revzephyr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2014, 11:47 PM
  4. [SOLVED] Three-layer dependent dropdown with validation query
    By SandPounder1 in forum Excel General
    Replies: 5
    Last Post: 03-10-2014, 03:14 PM
  5. [SOLVED] Dependent dropdown validation - dependent data is string
    By jnewby in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 07:50 PM
  6. 4 way dependent dropdown/data validation
    By Cidona in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-19-2012, 06:58 AM
  7. Excel 2007 : Dependent Dropdown (Data Validation)
    By mtpr220 in forum Excel General
    Replies: 16
    Last Post: 08-10-2011, 12:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1