Hi,

I don't believe predictive text is available with Data Validation.

I had to write a VBA procedure to mimic this. The essentials of which were to use a data filter advanced to filter a known list of values using the input cell characters with a "*" either side in a criteria range so that the filter outpust any values that contained those characters anywhere in the string.

This output list is the basis of a dynamic range name which in turn is used as the RowSource property for a ListBox on a user form. A selection can then be made from the ListBox if required and the value selected then placed back in the input cell.

Hope this gives you some ideas.