I have a column of texts of diagnosis description which looks like this:
upper respiratory tract infection
respiratory tract infection
lower respiratory tract infection
gastrointestinal tract disorder
gastrointestinal tract infection
and they are all mixed up....
So I would like to classify them into respiratory, skin, gastrointestinal
Can someone please help me with a formula which says : if a cell contains the part text (resp), or the part text (skin), or the part text (gastro), then return (respiratory, skin, gastrointestinal) otherwise nothing.
Thanks in advance