+ Reply to Thread
Results 1 to 4 of 4

Adding conditions to dropdown list

  1. #1
    Registered User
    Join Date
    01-17-2021
    Location
    HK
    MS-Off Ver
    2016
    Posts
    1

    Adding conditions to dropdown list

    Hi everyone, my first post and hope I make myself understandable...

    I'm trying to use the dropdown list function, so that I can find a specific data from a table. But I'm having a long list and would like to add conditions to it.

    I've seen people using dependent lists to solve similar problems, but since my list is a live one and it keeps expanding. Is there a way that Excel could list out the data that matches with the condition, perhaps like an if-function?

    Would be very great if you guys can help! Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Adding conditions to dropdown list

    Are you requiring Dropdown list in G4, including Ref No of Name in G2 and month in G3?

    Try to create list of Ref first in somewhere, i.e, N2:N13

    Then using OFFSET to create a dynamic list, using in Data Validation.

    Something like in attachment.
    Attached Files Attached Files
    Quang PT

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Adding conditions to dropdown list

    List is created in helper column M.
    In M2 then copy down
    Please Login or Register  to view this content.
    Formula for DV is

    =INDIRECT("M2:M" & COUNTIF($M$2:$M$100,">0")+1)
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Adding conditions to dropdown list

    No formula - No helper columns - No extra lists (that do not compare to 'master')
    All data is obtained from the 'master' therefore should be compatable.
    Click in 'G2' - select from 3 combos - values pass back to the sheet on final selection in third combo.
    With the magic of VBA.
    torachan.
    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. [SOLVED] adding an item to a dropdown list via the dropdown list
    By Learning ExL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2020, 02:32 PM
  2. [SOLVED] Adding results from dropdown list
    By jonhat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2018, 07:28 AM
  3. Adding dates and names to dropdown list
    By e0263817 in forum Excel General
    Replies: 1
    Last Post: 09-29-2015, 10:39 AM
  4. [SOLVED] ComboBox DropDown list keeps adding data
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2015, 04:18 PM
  5. Adding a dropdown list of names
    By AdamHaubert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2013, 10:54 AM
  6. Dropdown list with multiple conditions...
    By skadieverwinter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-24-2013, 09:33 PM
  7. Adding Value of Cells, but Cell Determined by Dropdown List
    By concretetsunami in forum Excel General
    Replies: 4
    Last Post: 03-09-2010, 04:19 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