Insert X if cell contains a value 1

[jh3016]

In cell K2, there are five words "apples pears strawberries watermelon grapes". I want to put an X in cell L2 if the word grapes appears in cell K2. Is there a way to do this?

 

[SkipVought]

Hi,

Try this...

=IF(ISERR(SEARCH(J1,K2)>1),"","X")

Where J1 has your value of grapes or whatever

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jh3016]

Thanks for the quick response. I did not explain properly.

What I'm trying to do is say if K2 CONTAINS "grapes", then put an X in L2. I just don't know how to do a CONTAIN.

 

[SkipVought]

That's EXACTLY what this does.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jh3016]

duhhhh!!!! oh my goodness. I'm so embarrassed. You are a genius. Thanks!!!!

 

[SkipVought]

Sorry, I meant to use L1 instead of J1 for clarity.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Zig1]

Hi jh3016,

Try this in L2: IF(ISERR(SEARCH("grapes",K1)),"","x&quot

You can use FIND in place of SEARCH, but it is case sensitive and will not find "Grapes" if you are looking for "grapes"

 

[jh3016]

OK, this works just great. One more question. How about if I want to say if K2 contains grapes or apples or oranges, put an "X" in L2.

 

[SkipVought]

My grapes are crushed and waiting for its TIME -- it's FRIDAY!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jh3016]

Huh?

 

[Zathras]

You'll have to excuse Skip. It's 105 degrees where he is. I think his brain is fried. [LOL]

[blue]

=IF(AND(ISERR(SEARCH("grapes",K1)),ISERR(SEARCH("apples",K1)),ISERR(SEARCH("oranges",K1))),"","x")

[/color]

 

[jh3016]

Thank you. This works like a charm!