using vlookup with 'contained strings'

[furma]

I have the following index values:

A3 = Audi
A4 = Audi
A5 = Audi
TT = Audi
120 = BMW
318 = BMW
550 = BMW
Fabia = Skoda
Octavia = Skoda
----------------
Using Vlookup, I easily mark "A3" cells as Audi, "120" cells as BMW and "Fabia" cells as Skoda.
I wonna mark as "Audi" also cells with the the string "A3 Quattro", or "A4 Roadster".
How do I do that?

[martindwilson]

add them to your index!

[furma]

tt quattro 225hp
tt quattro 180hp
tt quattro 4X4
etc..

[martindwilson]

without knowing all the models per marque it is quite hard to construct anything to find them
have you the list?

[sglife]

Try my sample in the attachment

[martindwilson]

that would work fine IF all the models are in the index!!!!!!!