Forum Discussion
Value doesn't match the data validation restrictions defined for this cell
I have data in cells drop down. How can I make it recognize the same data or first letter of the data drop and auto fill? Does this make sense?
2 Replies
- Please specify an example of the circumstances under which you want your drop-down list to work.
Hi,
This feature isn't supported in the dropdown lists.
But there are some third-party tools for this, such as this https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html.
The easiest workaround I suggest is to make the data validation source list somewhere in the same worksheet.
Then create a chain between the data validation dropdown list and the data source.
The chain trick is explained in this https://www.youtube.com/watch?v=PVEzHbdHf1Y.
Hope that helps
