Is it possible to use a formula/trick to create a drop down list that narrows as you type the name in the field.

E.g I have a drop down list linked to a data series that contains thousands of product names. Currently I have to scroll down to the correct item which can be difficult to find in order to select it. I would like to start typing the name in the field and have the drop down list automatically narrow down to only those products which have characters typed. If I started typing P, the list would narrow to Pan, Plate, Pot etc and exclude all other products in that data column.

Any help would be greatly appreciated