If you copied and pasted the formula into your spreadsheet, make sure a
line break hasn't been added.

Does this help?

In article ,
jh3016 wrote:

I get an error when I run this.

"Domenic" wrote:

Sorry, make that...

=IF(ISNUMBER(SEARCH("Grapes",H2)),"Grapes",IF(ISNU MBER(SEARCH("Oranges",H
2)),"Oranges","Neither"))

Hope this helps!

In article ,
Domenic wrote:

Try the following instead...

=IF(OR(ISNUMBER(SEARCH({"Grapes","Oranges"},H2))), H2,"Neither")

Hope this helps!