If Function

[Guest]

I want to write a formula like this: if column D contains the word zebra in
any cell, then each corresponding cell in column A will say Stripe
Can this be done?

 

[Scoops]

I want to write a formula like this: if column D contains the word zebra in
any cell, then each corresponding cell in column A will say Stripe
Can this be done?

Hi vacation

In A1 type =IF(D1="Zebra","Stripe","SomethingElse")

Copy down as necessary.

Regards

Steve

 

[Guest]

Thanks! That was fast. Its almost working. I neglected to say that the word
Zebra is part of a text string in the cell. I'm just looking for that word
and not the others. What do you suggest

 

[Guest]

If it is case-sensitive, use FIND(), otherwise use SEARCH()

IF(not(iserror(search(D1,"Zebra"))),"Stripe","SomethingElse")

 

[Guest]

The formula is producing the result SomethingElse for each cell in column
A...like its never seeing that Zebra is found in column D at all and
therefore never returns Stripe when it should.

 

[Guest]

Oops. Sorry about that..had some arguments reversed

=IF(NOT(ISERROR(SEARCH("Zebra",D84))),"Stripe","SomethingElse")

 

[Guest]

It works! Thank you!!!!

Oops. Sorry about that..had some arguments reversed

=IF(NOT(ISERROR(SEARCH("Zebra",D84))),"Stripe","SomethingElse")