Vlookup - If cell contains characters from list, use list to return value

Hi,
Apologies ahead of time if this has already been answered. I've looked but can only find the answers reversed from what I need.

I have a list of service names (A2:A100).
I have a reference list (Tab="Mapping") of how I want to mark each service if it contains certain words/characters (A2:B12).

Service Names:

Spanish Language Service
Americas En Espanol Web VOL
Delivery Fee for Italian Service
Bourse News

Mapping

(A) If contains (B) Mark As
Bourse French
Spanish Spanish
Espanol Spanish
Italian Italian

So I want to lookup the product, and if it contains MappingA, return MappingB. There are no set number of characters, and the word can be anywhere in the product name.
I've tried using wildcards, but they only seem to work if the wildcard can be used in the lookup value. I need it in the table array...

Thanks in advance!

Hello
Try the following:

Formula:

Please Login or Register  to view this content.

Here the Service name is in A2 and the lookup lists are on the 'Mapping' tab in A2:B5. No match will return '#N/A', if there's more than 1 match it will the return the last on the list.

*Note of credit to Tony Valko for the LOOKUP solution.

Hope this helps.
DBY

That's perfect - thank you so much!!!

Glad to have helped. I've just realized that the VLOOKUP isn't necessary, just amend the 'Result Vector' (red) of the LOOKUP to:

Formula:

Please Login or Register  to view this content.

Sorry not thinking straight!