how can i make a pulldown list with autocompleet and first letter reconiction.

I have the list working with data validation
but now the rest.

The list is on sheet 2

I am now using the data Validation with list as allow
The source formula is "=Workcode" (area name) and workcode is on sheet 2.
Sheet 1 is used to display the list.

thanks