Hi all,

I have a list of categories to indicate employee disciplines, i.e
Management
Electrical
Mechanical
Other
and so on.

I have other cells within my spreadsheet that have text that includes the
categories above. For example,

Electrical Engineer
Senior Electrical Engineer
Junior Electrical Engineer

I would like to search these text strings using the categories above to
return only the category. Therefore, if i had A1 = Electrical Engineer, B1
needs to be a formula that gives the result of Electrical. If I then changed
A1 to Mechanical Engineer, B1 needs to automatically change to Mechanical.

Any suggestions

--
J