Excel vlook up type formual needed to harvest specific words
I have a dataset with a very long drug names (drug compound mixture) in one field. Here is sort of an example:
10% Neostigmine OR anesthesia 1mg 5ml BD syringe 1540 Methyl 18%
The main drug in this compound is Neostigmine.
I have a list of about 100 drugs and this is one. I need to create some sort of look up that will look for and bring in the single main drug name of (Neostigmine) beside the very long compound name.
The main drug names within the compound name can be located in various places within the long compound name.
I can either do this in EXCEL or ACCESS - help appreciated.