Searchable List Excel VBA or Formula

Frequent Contributor



I would like to be assisted with a formula or VBA that could accomplish this task. I have attached the file with explanations.


Thank you !



4 Replies


See the attached version. It is based on Data Validation Combo box Click 

Since the workbook now contains VBA code, you'll have to allow macros when you open it.

best response confirmed by A_SIRAT (Frequent Contributor)
Try a free Excel add-in called “Search deList”.
Please, check this discussion:
Thank you Hans once again.

Thank you !

Let me check the discussion..