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))...