conditional value in a cell

V

Vic

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:________________________________"
 
P

Per Jessen

Hi

Use this formula in M2:

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

Regards,
Per
 
Top