Help me to manage covid vaccination in my health center pleaze !

%3CLINGO-SUB%20id%3D%22lingo-sub-2231990%22%20slang%3D%22fr-FR%22%3EHelp%20me%20to%20manage%20covid%20vaccination%20in%20my%20health%20center%20pleaze!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231990%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20find%20the%20right%20formula%20to%20get%20this%3A%3C%2FP%3E%3CP%3Eif%20cell%20A1%20contains%20the%20word%20%22astrazeneca%22%20OR%20the%20word%20%22comirnaty%22%20the%20%22yes%22%20or%20%22no%22%3C%2FP%3E%3CP%3EThanks%20you%20very%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2231990%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello everybody,

 

I would like to find the right formula to get this :

if cell A1 contains the word "astrazeneca" OR the word "comirnaty" the "yes" or "no"

Thanks you very much ! 

1 Reply

@Elieliza 

As variant

=IF( SUM(COUNTIFS(A1, {"*astrazeneca*","*comirnaty*"})), "Yes", "No")