Forum Discussion
Solved
How check if cell value agrees with another list/table
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, naproxn...
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)
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)
Thank you very much!!