Searchable List Excel VBA or Formula

[A_SIRAT]

Hi,

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 !

[#2]

@A_SIRAT 

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.

[#3 · Accepted solution]

Try a free Excel add-in called “Search deList”.
Please, check this discussion:
https://techcommunity.microsoft.com/t5/excel/searchable-dropdown-lists-on-multiple-rows/m-p/3647239/...

[#4]

Thank you Hans once again.

[#5]

Thank you !

Let me check the discussion..