On Thursday, January 21, 2016 at 10:05:35 AM UTC, Claus Busch wrote:
Hi,

Am Thu, 21 Jan 2016 01:56:52 -0800 (PST) schrieb :

But I still need it to search the words *apples* and *bananas* and if neither word is displayed display error, how would I string to search multiple words and if none of them words are displayed then *error is displayed?


sorry, I thought you could create it by yourself.
Try:
=IF(ISNUMBER(SEARCH("apples",A1)),"apples",IF(ISNU MBER(SEARCH("banana",A1)),"banana","error"))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Your support is much appreciated!!

I found a formula that works;

=IF(COUNT(SEARCH({"Apples","Bananas","Carrots"},C1 )),"Fruit","error")

Thank you for your help though!