Data validation list with a search/filter option

[Sadhna]

Hi,

Please assist with a solution for creating a data validation list which has a data filter/search option.

Attached is my file. The data validation list is in column C.

Below is a standard data validation cell:

 

[Chihiro]

See if this works. Note that you'll need to turn on Iterative calculation in the options for this to work.

Concept expanded from link below.
https://chandoo.org/forum/threads/searchable-drop-down-without-vba.38037/