Hello all,

I am in need to search a row for a term then return the value found to to a cell.

For instance
Search words
Apple
Banana
Strawberry
Pear
Watermelon

If any cell from B2 through E2 contains one of the search words then send that search term to B1. It would be nice if more than one was found it could show more than one result

I will have thousands of rows to search.