How do I search a string for a lookup value?

[Salmons5901]

I want to search a string to find a value to lookup against for a vlookup, but am new to vb etc so not sure where to start. Example I have a list of cars and there type; GOLF 5DR TDi, A3 3DR 140 or 2DR A5 Cabriolet etc etc including loads of different details. With a lookup list of Golf, A3, A5 I would like it to search the string for that model and then return it. Exactly like a normal lookup but searching the string for the lookup value. So there doesn't need to be an exact match for the full string just that one word/model name. I tried using wildcards but with no success. Any help would be much appreciated. Thanks

<TBODY>
</TBODY>