Hi,
I'm still pretty new to Excel, but I have a massive listing of people's names and titles. I need a way to search for keywords within their job titles in order to fill in a corresponding job role in the next column. Is this possible?
I tried using a =IF(ISERROR(SEARCH("*dentist*",C5,1)), "", "Dentist"), but I have a large list of job names and roles - it also cuts me off at 7 entries.
I then looked into arranging a vlookup with the hopes I could associate the vlookup formula to a corresponding table or sheet listing all the possible variations of that name corresponding to a role. Does this make sense?
For example:
Name Job Title Job Role Department
--------------------------------------------------------
Betty Super Dentist ? ?
Joe Prof. Clown
Tim Baby Doctor
Bobby Adult Baker
Corresponding table:
Word Role Department
--------------------------------------
Dentist Dentist Medical
Clown Clown Entertainment
Doctor Doctor Medical
Baker Baker Food
I would like to somehow search for a series of keywords in one column and then auto-fill the next column over with the correct role name and from that role the correct department.
Please let me know if I need to clarify. I have a ridiculous collection of titles to search through.
Thank you so much for your help!
I'm still pretty new to Excel, but I have a massive listing of people's names and titles. I need a way to search for keywords within their job titles in order to fill in a corresponding job role in the next column. Is this possible?
I tried using a =IF(ISERROR(SEARCH("*dentist*",C5,1)), "", "Dentist"), but I have a large list of job names and roles - it also cuts me off at 7 entries.
I then looked into arranging a vlookup with the hopes I could associate the vlookup formula to a corresponding table or sheet listing all the possible variations of that name corresponding to a role. Does this make sense?
For example:
Name Job Title Job Role Department
--------------------------------------------------------
Betty Super Dentist ? ?
Joe Prof. Clown
Tim Baby Doctor
Bobby Adult Baker
Corresponding table:
Word Role Department
--------------------------------------
Dentist Dentist Medical
Clown Clown Entertainment
Doctor Doctor Medical
Baker Baker Food
I would like to somehow search for a series of keywords in one column and then auto-fill the next column over with the correct role name and from that role the correct department.
Please let me know if I need to clarify. I have a ridiculous collection of titles to search through.
Thank you so much for your help!