Hey guys,

I got a job to categorise the Job titles in our CRM database into 3 tiers and a negative tier (for lead grading purposes).
A previous colleague started building up a ruleset which uses keywords to get a certain job title into category: Tier 1, Tier 2, Tier 3 or Negative Tier

Now this keyword list misses a very large portion of the database so what I am trying to achieve first is to check if a job title was tiered already and which tier does it belong to.

Since I can't attach upload the file here is a link to a Google sheet to show what I mean (it has 2 worksheets, the second has the keywords): https://docs.google.com/spreadsheets...it?usp=sharing

Because of the keywords a simple VLOOKUP doesn't work. It would need some kind of wildcard lookup. Additionally I would want the function to fill in the columns near the every job title, saying if it is in Tier 1, 2, 3 or negative.
I have filled in the first 3 rows in the spreadsheet manually to show what I would to achieve.

Is this doable? Can anyone help me out with this?
Since I am a very beginner in excel I would really appreciate any help you can give

Have a great day!

Balint