If formula where cell contains a range of values

Oh i missed the last line. This formula returns true/false only. If you want, put the formula structure as Pete_Uk mentioned.

Formula:

=IF(ISNUMBER(MATCH("*DW-EXP*",A1,0)),"DW-EXP",IF(ISNUMBER(MATCH("*DW-DEP*",A1,0)),"DW-DEP",IF(ISNUMBER(MATCH("*AW-EXP*",A1,0)),"AW-EXP",FALSE)))

Thanks for the help :-)