Mark cells in Column B that have text matching any cell in Column A

Thanks for any help you can provide! In column A, I have certain category phrases:

Column A
Ach
Terr
Marv

In column B, I have cells with different titles:

Column B
The Achilles Battle
The Achilles Sneeze
Lightning Round
Terrible Noises
Terrific Job
Intensity
Marvelous

My goal is to 1) search each column in Column B, 2) determine if any of the category phrases are found within, and then 3) mark column C with the category phrase that matches.

VLookup doesn't seem to work here because I don't know how to make Column A a wildcard match. Any ideas?

http://www.myonlinetraininghub.com/e...if-and-vlookup

This answer worked for me! Thanks, Tony!

- Kevin

Originally Posted by Tony Valko

Try this...

This data in the range A2:A4...

Ach
Terr
Marv

This data in the range B2:B8...

The Achilles Battle
The Achilles Sneeze
Lightning Round
Terrible Noises
Terrific Job
Intensity
Marvelous

Enter this formula in C2 and copy down to C8:

=IFERROR(LOOKUP(1E100,SEARCH(A$2:A$4,B2),A$2:A$4),"")

Thanks, Mallycat, but Tony's response was more specific to my needs.