How check if cell value agrees with another list/table

[CiliaJ1010]

Hello everyone, 

I have a problem with excel. I have a long list with different kind of drugs and I want to know which type of drugs are NSAIDs (specific type of drug, example: ibuprofen, naproxne, diclofenac). I want to check if a certain cell value (the NSAIDs) are present in my long list of drugs. 

Most ideal I would get a formule, which results in 0 = no NSAID, 1 = NSAID for every type of drug. Does anyone maybe has a solution for my problem?

Thanks in advance!!!

Drug	NSAID?		NSAIDS
PARACETAMOL TABLET OMHULD 1000MG			IBUPROFEN
PARACETAMOL TABLET 750MG			NAPROXEN
IBUPROFEN Pill 200MG			DICLOFENAC
NAPROXEN Suspension 500MG
IBUPROFEN TABLET 100MG
COLISTINE Injection 1000MG
GENTAMICINE Injection
DICLOFENAC TABLET 1500MG
AMOXICILLINE TABLET OMHULD 500MG

[#2 · Accepted solution]

@CiliaJ1010 See attached!

Edit:

If it may occur that he NSAID name is not in the first word of the full name of the drug, use this instead in C4 and copy down:

=--(SUM(IFERROR(SEARCH(nsaids,B4),0))<>0)

[#3]

Thank you very much!!