How do I search a string for a lookup value?

[Salmons5901]

<TBODY>
[TD="class: votecell"][/TD]
[TD="class: postcell"]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


[/TD]

</TBODY>