Customised Drop Down List

[Busymanjohn]

Hi, I am looking to be able to have a drop down list that has the ability to allow the user to have more than one choice ,, i.e. a drop down list of say employee names but if someone wanted to just show those that begin with A for example it will show every employee name that begins with A. Is this possible with drop down lists at all?

 

[jeffreyweir]

Excel Tables and pivottable have this functionality built right in.


Otherwise you'll probably have to use some code. There's a sample file at http://www.excelhero.com/blog/workbooks/partial_match_lookup_optimized_excelhero.com.xls and a longer blog post on this at http://www.excelhero.com/blog/2010/07/excel-partial-match-database-lookup.html


Might help if you upload a sample workbook, as no doubt others will find other approaches once they see what you want to do.

 

[SirJB7]

Hi, Busymanjohn!

Here at chandoo.org you may find useful links too:

http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

http://chandoo.org/forums/topic/dynamic-search-bar-in-excel-from-partial-input

http://chandoo.org/forums/topic/return-multiple-items-for-single-look-up-value-and-use-wild-card-to-count

... and there are more, just try using the search feature at top right.

Regards!