Try the following instead...

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

Hope this helps!

In article ,
jh3016 wrote:

The formula works if H2 has "Grapes" or "Oranges" exactly. What I need is if
it CONTAINS "Grapes" or "Oranges".

Thanks again.

"Domenic" wrote:

Try...

=IF(H2="Grapes","Grapes",IF(H2="Oranges","Orange", "Neither"))

Hope this helps!

In article ,
jh3016 wrote:

I have a simple question, I believe.

I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2
contains "Oranges", then enter "Oranges in J2. If H2 does not contain
Grapes
or Oranges, enter "Neither" in J2.

Can someone give me the formula for this?

Thanks in advance.