Hi jaymanwani7,

you won't be able to do that with a data validation list. But if you use a listbox instead and a little VBA code that runs in the background, you can achieve autocomplete/autofilter functionality.

Have a look here: http://www.dailydoseofexcel.com/arch...mit-a-listbox/