I am currently using a nested '=find(text,cell)' formula to categorise a list for example.
If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'.
This I have done by nesting separate find fictions for each key work with an if statement...