Data Validation

Occasional Visitor

I cannot perform a search on my dropdown list.
I start to type a word, nothing is suggested, and when I hit enter, a message appears that states 'This value doesn't match the data validation restrictions defined for this cell'.
I don't know how to fix this problem.

1 Reply

search on my dropdown list.

like this?


Build-in validation not support this, as far as I know.