View Single Post
  #8   Report Post  
Domenic
 
Posts: n/a
Default

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!