+ Reply to Thread
Results 1 to 2 of 2

Creating validation list from table column based on data in another column

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Creating validation list from table column based on data in another column

    If I have a table as noted below with the following assumptions:
    - this table will likely grow
    - the 'Include' column data will change based on external criteria/formulas, so the 'Include' column will not be sorted.
    - Macros aren't an option as this sheet needs to be macro free.

    A B C
    1 Item Calories Include
    2 Orange 80 Yes
    3 Apple 80 Yes
    4 Banana 100 No
    5 Grapes 50 Yes
    6 Bread 40 No
    7 Butter 200 Yes

    How do I build a formula that I can place in a data validation drop down to only include 'Item's that have Yes indicated in the 'Include' column?

    I've been researching this and found answers if the 'Include' column was sorted via offset, but I haven't found any to sift through when unsorted. I feel like there is a simple answer to this that I am missing. Here is the sheet --> ExampleSheet.xlsx

    Thanks,

    dreamthrum
    Attached Images Attached Images
    Last edited by dreamthrum; 12-11-2013 at 05:43 PM.

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Creating validation list from table column based on data in another column

    Try the attached workbook
    Attached Files Attached Files

+ 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: 3
    Last Post: 10-28-2013, 03:33 PM
  2. Creating 2 Column List Based on 1 Column of Data... with a catch. :)
    By samebito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 06:41 PM
  3. Replies: 1
    Last Post: 07-13-2012, 10:11 AM
  4. Supply a column of table as a Data Validation list
    By Chandrajit in forum Excel General
    Replies: 7
    Last Post: 03-11-2012, 05:01 AM
  5. Replies: 3
    Last Post: 08-21-2011, 08:22 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