Hi all - I could use help with the following problem.
In column A, I have a string of words. (e.g. Senior Process Engineer - Plano, TX)
In sheet 2, column B through column D, I have up to 3 keywords the help me categorize the string and in column E, I have the name of the category. (e.g, Columns B-D, "engineering", "engineer", "CPE". Column E, "Engineering")
I have about 25 categories, thus about 25 rows.
What formula or Macro can I write that essentially says, "If the keywords in columns B-D appear in the string in column A, return the value from column E"
I feel like I've been close with a series of formulas, but haven't been able to figure it out.
Any help would be greatly appreciated. If I can clarify in any way, please let me know. Thanks!