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!
|