Use IF and Find function together

Posted by Armando Parra on October 19, 2001 9:28 AM

I am trying to use an if and find function to look at a cell for a word within 4 words, if it is there then give me the information on its right if not look at another cell. I am having problems, can some one help me or direct me to where I can find the answer. Thanks

Posted by Mark W. on October 19, 2001 9:34 AM

Suppose cell A1 contains the text "one of four words".
=IF(ISNUMBER(SEARCH("*four*",A1)),B1,C1) will
return the value in cell B1 because if found the
word "four" in cell A1.

Posted by Armando on October 19, 2001 10:26 AM

Thanks Mark you just cured my headache.
Armando