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
Bookmarks