Looking into a list and returning that products' code

I wonder if someone can tell me how in VBA code I could from a user's input which might not be exactly right.

In most cases the mapping needs to probably work from the first word that the user enters i.e. the user might have typed just the word "Repair" and in my list of codes there is the following options:

Repair of cars
Repair of boats
Repair of ships
Repair of work-tops

I need these choices to come up as a pull down option list where he can select the right one unless he has an identical match. From this there will be a code in column A which is a number I want this number to be copied into my "New Data" sheet.

Any ideas?

Francis