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 documents here is a link to a Google sheet to show what I mean: https://docs.google.com/spreadsheets/d/1W6TVjpbmvQFXOPWhG61J7lt_dkgkV57OO8C7teo2fP8/edit?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
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 documents here is a link to a Google sheet to show what I mean: https://docs.google.com/spreadsheets/d/1W6TVjpbmvQFXOPWhG61J7lt_dkgkV57OO8C7teo2fP8/edit?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