+ Reply to Thread
Results 1 to 2 of 2

List with specific criteria

  1. #1
    Registered User
    Join Date
    12-11-2005
    Posts
    15

    List with specific criteria

    HI All,

    Need some help,

    I want a list that contains options J, M, N

    using the list you select either J,M, N

    The subjects for the options will be avilable for the list.

    Does anyone know how to do this and if they can show me an example.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: List with specific criteria

    list #1: data validation, (in H3)
    allow: list,
    source: J,M,N
    dependent dropdown #2 (in J3)
    source: list
    allow: =INDEX($D$4:$F$5,0,MATCH($H$3,$D$3:$F$3,0))
    Attached Files Attached Files
    Last edited by protonLeah; 12-01-2020 at 04:44 PM.
    Ben Van Johnson

+ 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] List specific data by Criteria out of a complete list
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-27-2019, 07:08 AM
  2. List of contacts matching specific criteria
    By anhlu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2017, 12:33 PM
  3. Looking for a simple list of random numbers (very specific criteria)
    By johnnywharris in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-09-2013, 11:58 AM
  4. return a list with specific date criteria
    By vinceli in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-08-2013, 07:35 AM
  5. [SOLVED] Create a list given specific criteria?
    By rhihenderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2013, 02:44 PM
  6. Replies: 2
    Last Post: 03-30-2011, 08:05 PM
  7. List Specific Data per Criteria
    By USChad in forum Excel General
    Replies: 3
    Last Post: 01-08-2007, 10:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1