search text string in a column and see if it matches a value in a different tables column

[ScORE]

I need help searcing searching a text string in a column to see if it matches a value in a different tables column.  The tables are not connected.  If the text string contains the value, I want to return another value into a new column.  Sample tables: 

 Table 1                                                                                             Table 2

Full Name	Company		Comeidans on set	Sets today
John Stewart	Laugh out loud		John Stewart, Kevin Hart	1
Terry Fator	Funny Business		Terry Fator, Ricky Gervais	2
Larry David	Laugh until your stomach hurts		Larry David, Chevy Chase	3
Gary Chandler	US laughs		Gary Chandler, Jay Leno	4
Jim Gaffin	Electric comedy		Jim Gaffin, David Letterman	5
Dave Chappelle	Comedic Comedy		Dave Chappelle, Adam Sandler	6
Jerry Seinfeld	Funny Guy		Jerry Seinfeld, Vill Murray	7

Basically, I want too search/look in the comedians on set column, for a match to one the names in my full names column and return the company in a column in the table with comedians on set as a value.  example:

seach comedians on set line 1 find john stewart as a match and return Laugh out loud as avalue in a new column in my comedians on set table.  

Your help is greatly appreciated!!!