Download the featured file here: [ Ссылка ]
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.
------------------------
![](https://s2.save4k.ru/pic/uVpx2V0dFk0/maxresdefault.jpg)