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?
Bookmarks