+ Reply to Thread
Results 1 to 7 of 7

Help with Macro/formula - Lookup that returns Dropdown List of matches

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Help with Macro/formula - Lookup that returns Dropdown List of matches

    Hi Guys,

    I have a data sheet that has nodes and paths, and another where i just have nodes, some or the nodes have different paths i need to lookup the nodes and return the most relavant path if there are more than one result values, so i need a macro/function that if there are more than one result create an inline dropdown list with all the matching values just like a data validation dropdown, i;ve given examples in the sheet attached below.

    any help will be greatly appreciated or I will have to do this manually


    Thanks

    Alfred
    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,572

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

    Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

    Have you started any work on this project yet?
    How far did you get?
    Where are you stuck?

    We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-13-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    ReturnMultpleValues.xlsxHi All,

    Im not that good at programming so i came here. I was able to get a function that returns all the matching values seperated by a comma, now all i need is how to get them in a dropdown in the cell.

    Please Login or Register  to view this content.
    Attached workbook.


    Thanks

    Alfred

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    Hi Alfred. Try to make a double-click in column A. If there is only one node, then only one path will appear in the next cell. If there are multiple nodes, the combobox will appear to select a path.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-13-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    Hi Nilem,

    thank you so much this is awesome! is there any way i can make this into an addin so i can use it on other sheets? right now i can only use this on the problem sheet in column A,

    The data sheet values wont change, is there a way to make this an excel addin so i can use the macro on any cell in anyother workbook?


    Thanks ALOT!


    Alfred
    Last edited by Cutter; 09-23-2012 at 09:20 AM. Reason: Removed whole post quote

  6. #6
    Registered User
    Join Date
    12-13-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    ReturnMultipleDropDownSample.xlsm

    Hi Nilem ,

    Here you go.

    Thanks ALOT!

  7. #7
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Help with Macro/formula - Lookup that returns Dropdown List of matches

    two options, try
    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)

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