Just as title says:

IF range of cells contains string of text, return contents of cell where string is found

For example

Col A

dog
cat


Col B

the dog ran
the (cat) walked
the (dog) ran
the cat walked

So a formula that would search for the contents in A1 and return the entire cell B1