Simple IF formua for searching for a word in a cell

**Virtuallynne** · 05-10-2012, 04:40 AM

Hi

, Hoping you would be so kind as to help me with a basic formula that searches 1 cell for a certain word.
If the cell contains the word then it will display the contents of the cell that is adjacent to it

eg if cell A1 contains "its a beautiful day" and we are searching for the word "beautiful" then the contents of cell B1 will be displayed.
if the rule is not met then nothing is displayed.

Thanks so much in advance

**zbor** · 05-10-2012, 04:48 AM

Try:

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

**Virtuallynne** · 05-10-2012, 04:53 AM

You are my superhero for today, thanks for the speedy response too as it was quite urgent

**Marcol** · 05-10-2012, 05:02 AM

Perhaps you might also consider if the word to find should be case-sensitive or not

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

FIND() is case-sensitive, SEARCH() isn't

**Virtuallynne** · 05-10-2012, 05:07 AM

thanks, Marcol that is going to be useful as there are different cases/combinations. I hope you have a lovely day.

**Marcol** · 05-10-2012, 08:01 AM

Please don't PM members with further questions, see the Forum Rules, Rule #4.

Your PM

Hi Marcol
Thanks again, would you know if its possible to add to the formula so that it looks for a few words and not just one word.

eg "beautiful" Or "Day" Or "Night" and if it contains ANY of those words then it reurns the value as it already is.
It would be a great help

See if this workbook helps.