conditional value in a cell
 

I need to put Yes in cell M2 if cell J2 has "DSMB" anywhere in its' text.

Here is an example of text that may be in cell J2:
"Priority DSMB/Discontinuation Query: End of ... page 55 shows primary
reason for discontinued as "Client Decision". Please provide the
comment/specification explaining the rationale that the client provided as to
"why" they chose to discontinue services:________________________________"

conditional value in a cell
 

Hi

Use this formula in M2:

=IF(ISERROR(SEARCH("DSMB",J2,1)),"No","Yes")

Regards,
Per

"Vic" skrev i meddelelsen
...
I need to put Yes in cell M2 if cell J2 has "DSMB" anywhere in its' text.

Here is an example of text that may be in cell J2:
"Priority DSMB/Discontinuation Query: End of ... page 55 shows primary
reason for discontinued as "Client Decision". Please provide the
comment/specification explaining the rationale that the client provided as
to
"why" they chose to discontinue services:________________________________"

conditional value in a cell
 

Try this in M2

=IF(SEARCH("DSMB",J2),"Yes","")

Mike

"Vic" wrote:

I need to put Yes in cell M2 if cell J2 has "DSMB" anywhere in its' text.

Here is an example of text that may be in cell J2:
"Priority DSMB/Discontinuation Query: End of ... page 55 shows primary
reason for discontinued as "Client Decision". Please provide the
comment/specification explaining the rationale that the client provided as to
"why" they chose to discontinue services:________________________________"