Assign Categories Based on Keywords in Excel | Check if Cell Contains Text From List

In this video I demonstrate how to categorise text values based on a list of keywords.

I have a list of course names. If the course name contains words like Excel or Outlook, I want to categorise the course as a Microsoft course. If the course name contains words like InDesign or Premier, I want to categorise the course as an Adobe course.

The functions featured in this video tutorial are SEARCH, MATCH and INDEX.
------------------------

[moi]

This is the only video on youtube that handels this specific topic. This man deserves a lot more recognition!!!

[investathon]

I am not kidding. This is the single most helpful Youtube Video I have ever seen. It is specific only to a very small subsection of Excel issues, and saved me immense time. Thank you.

[jokecol]

Thank you Chester! This is the best example I've seen covering keywords and incorporating into formulas.

[michaelchelico]

Holy crap. This worked. I'm not even sure I want to know how it worked, but it worked. So good.

[dinzakas]

Amazing, must have solved many people's requirement.

[josemendozavazquez]

Holy Molly... this is exactly what I was looking for... Super excited I found this. Definitely had to view it like 3 times but I think I got it to work on my file.

[IvanCortinas_ES]

Excellent Chester. Important that you always explain the nuance or difference of using Excel 365. Thank you.

[Shekanereal]

This is exacltly what I was looking for, greatly appreciated Chester, you've been a massive help!

[whonos]

Honestly, I was pulling my hair out trying to figure out how to do this. You're a master.

[billbailey]

THANK YOU X 10^6 times Chester! You saved me so much time! Huge help in categorizing expenditures using keywords for tax purposes.

[zakirmomo]

Thank you very much dear Mr. I've been looking for the solution of this specific topic for months.

[thetuskers]

You are a star! I have been to trying get the exact same result to categorise my personal expenses from a bank statement! Thanks a lot! Stumbled upon you channel after going through a ton of other videos and websites.. Subscribed!

[ireneoiialcaide]

Thank You so much. I've been looking for this method for some time now, this video is truly a big help for me and my colleague More power and looking forward to your new videos. God Bless

[miljanapauzenberger]

Chester, you are a genius!!! Thank you for the great content and for sharing your vast knowledge. It is truly very much appreciated.

Looked for a solution for this for so long, glad I finally found. Very well explained, thanks

[Ajaysethumadhavan]

Thankyou very This video just helped me at the right time.... Kudos to your efforts 👍👏👏

[janmae]

I love the explanation! This is what I was looking for. Liked, subbed, commented. Thank you, kind Sir!

[pinpointa]

Chester, you are a legend for this. Thank you!

[chunkymm]

This is amazing!!!! I am so lucky to come across this video you made. Thank you Chester!!

[mattirons]

Finally! Been looking everywhere for a video like this! Thanks a lot