Searchable Drop Down List

[Panoos64]

Hi to all of you, I would like to create a "searchable drop down list" for my invoice by which when i enter 2,3,4 ....letters in cells, column “C” starting from “C11” and rows down, should appear the items by alphabetical method based on the initial letters which i enter so that to have the option in a shorter list, to select the right one on invoice. Note that the invoice is in Sheet1 and the codes in Sheet2. I present below an extract of the 2 Sheets. I would much appreciate if you could write me the step by step so that to find the solution for my project. Thank you all in advance

Sheet1

Sheet2

 

[Akuini]

If you're willing to use and add-in, try using "Search_deList_v2.1", it's a free Excel add-in, it works on Excel 2007 or later.

Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.

By using this add-in, you don't need VBA to have this searchable combobox, so you can save your files as .xlsx.

This new version (updated in 2022-Nov-18) has some additional features, some of them:

• Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
• Sort the list by original order or ascending order.
• Widen or shorten the combobox width at run time.
• Insert multiple entries into the cell.

You can find it here (please check post #81 and also post #68 for full description):

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

 

[Panoos64]

Dear Akuini, thank you for your suggetion to resolve my issue by this way. I will attempted to develop my system using the "Combo Box" and in case that i have any queries i will let you know. Thank you once again for your support. Hv a great day

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.