Hi, Ive been helped with the following formula and wondering if anyone knows if I can add additional words for it to search for (still in the same cell).. Just a little tweak..

eg if cell A1 contains "its a beautiful day" and we are searching for the word "beautiful" or "Day" or "Strawberries" then the contents of cell B1 will be displayed becuase one of the words is contained in A1.

=IF(ISNUMBER(SEARCH("Beautiful", A1)), B1, "")

If A1 contains one of the words then it will display the contents of B1.

Thanks for helping it's so appreciated.