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

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

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.

ReturnMultipleDropDownSample.xlsm

Hi Nilem ,

Here you go.

Thanks ALOT!

two options, try