+ Reply to Thread
Results 1 to 2 of 2

Multiple Searchable Dropdown List

  1. #1
    Registered User
    Join Date
    03-30-2019
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    1

    Multiple Searchable Dropdown List

    Let,
    A2 is a drop list with source: Sale,Purchase
    B2 is also a drop list with source: =IF($A2="Sale",List Sale,List Purchase)
    Before that, In name manager, List Sale=Apple Juice, Orange Juice, Coconut Shake and List Purchase= Apple, Orange, Coconut

    Now if you can see..if I select Sale in A2, automatically in B2 will contain Apple Juice, Orange Juice and Coconut Shake and it works for the other too. Then copy both cell and paste into multiple column.. but the problem is that my drop list is not searchable like not giving narrowed down suggestion.

    I dont want any VBA or Micro solution because I need it in classic formula. Thanks.
    Attached Images Attached Images
    Last edited by Jackme; 03-30-2019 at 02:40 AM. Reason: Picture attached not related to the subject

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Multiple Searchable Dropdown List

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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: 5
    Last Post: 11-15-2018, 11:02 AM
  2. Searchable dropdown with variable source range
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2018, 06:55 AM
  3. Replies: 3
    Last Post: 01-17-2018, 11:55 AM
  4. Searchable dropdown
    By InvalidTxtString in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2016, 05:39 PM
  5. Searchable Drop Down List-Multiple Lines
    By simple? in forum Excel General
    Replies: 6
    Last Post: 10-13-2016, 06:07 AM
  6. Dropdown list effects multiple dropdown list
    By pvaldez in forum Excel General
    Replies: 1
    Last Post: 05-07-2010, 02:12 PM
  7. [SOLVED] searchable dropdown lists
    By pblenis in forum Excel General
    Replies: 2
    Last Post: 07-11-2006, 02:00 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