IF_ISNUMBER_FIND

Single value

=IF(ISNUMBER(FIND("text to find",within cell or range eg A1)),"THERE","NOT THERE")

Multiple values - maximum of 6

=IF(ISNUMBER(FIND("one",A1,1)),101,IF(ISNUMBER(FIND("two",A1,1)),102,IF(ISNUMBER(FIND("three",A1,1)),103,IF(ISNUMBER(FIND("four",A1,1)),104,IF(ISNUMBER(FIND("five",A1,1)),105,IF(ISNUMBER(FIND("six",A1,1)),106,0))))))