How check if cell value agrees with another list/table

Question

Hello everyone,&nbsp;&nbsp;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.&nbsp;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?&nbsp;Thanks in advance!!!&nbsp;DrugNSAID?&nbsp;NSAIDSPARACETAMOL TABLET OMHULD 1000MG&nbsp;&nbsp;&nbsp;IBUPROFENPARACETAMOL TABLET 750MG&nbsp;&nbsp;&nbsp;NAPROXENIBUPROFEN Pill 200MG&nbsp;&nbsp;&nbsp;DICLOFENACNAPROXEN Suspension 500MG&nbsp;&nbsp;&nbsp;&nbsp;IBUPROFEN TABLET 100MG&nbsp;&nbsp;&nbsp;&nbsp;COLISTINE Injection 1000MG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GENTAMICINE Injection&nbsp;&nbsp;&nbsp;&nbsp;DICLOFENAC TABLET 1500MG&nbsp;&nbsp;&nbsp;&nbsp;AMOXICILLINE TABLET OMHULD 500MG&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Accepted Answer

CiliaJ1010&nbsp;See attached!&nbsp;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))&lt;&gt;0)&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

How check if cell value agrees with another list/table

2 Replies

Resources

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