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

[@moi984]

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

[@PositivePeopleCommission300]

Exactly!

[@investathon8617]

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

[@shannawheeler2700]

Thanks! Been searching and cussing out google all morning. This is exactly what I needed to automate some banking activity.

[@jokecol1583]

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

[@michaelchelico1]

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

[@whonos]

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

[@josemendozavazquez8266]

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.

[@Shekanereal]

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

[@pinpointa]

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

[@ChesterTugwell]

You're welcome!

[@zakirmomo9578]

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

[@dinzakas]

Amazing, must have solved many people's requirement.

[@IvanCortinas_ES]

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

[@050224011]

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

[@mattirons4909]

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

[@moysesdutra]

Excelent, Thanks for sharing. I was looking for exactly this solution. Great explanation.

[@thetuskers1]

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!

[@chunkym0m0]

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

[@jaimezarza6656]

Excellent solution. I will save a lot of time. Thanks

[@billbailey5689]

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

[@DunkDrives]

My dude, you're a life saver! Thank you!!

[@purenick]

Very informative and helpful video. Many thanks!

[@LeanLeaderInsights]

Thank you for helping us out with category

[@pujolaksono5881]

very helped with your detailed explanation! Thank you very much!

[@ireneoiialcaide7283]

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

[@napatkumnuch8158]

Thank you so much. You’re ledge!

[@minchi2k1]

Exactly this is what I was also looking for... Thanks a lot!!! It worked like a gem.

[@miljanapauzenberger]

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

[@Ajaysethumadhavan]

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

[@janmae19]

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

[@ganlyb]

Brilliant. I have been looking for you for so long. Excel just does not seem to get you want to do this this way around.

[@CHAPINONG]

just what i was looking for, and were well explained, so could understand what and why you did what you did. Thank you !🤙

[@lizthorp9623]

You're a lifesaver, thank you so much!

[@sheprev]

absolutely excellent

[@BalaOnlineOfficial]

Great..this formula help to categorise 5k lines 👍 thanks you

[@kennyash]

Super AWESOME! Thank you VERY MUCH! =) Great Stuff!

[@KhaledEssam-c1y]

you are a real life saver. but what if the same course is assigned to 2 categories, can we present the 2 categories together and if yes please tell me how. Thanks

[@carys8027]

Thank you so much!! Works a treat.

[@lenguyenvietanh392]

Thank you for this video, but if the text I want to categorize having 2 or more suited keywords, how can I assign it into 2 seperated categories?

[@nimeshyasitha38]

so helpful ❤❤

[@TirthJigneshJhaveri]

Thank you so much for this video! It was super helpful. I have one question though, How can we apply this same method to do multiple keyword search?? I really appreciate anyone's help on this.

[@estephanina]

Exactly what i was looking for! I was trying to do If is number search and kept hitting a wall

[@shantimustika65]

I MEAN THIS COULD GET MORE LIKES AND VIEWS! thank you chester :))

[@yadayadanada]

This is so good... however i am having issues when the data set includes partial text of another cell. Like S-10 and S-100, I need the result to be S-100, but S-10 comes first so there are issues.

[@khaledismail908]

Thanks very much

[@mayaramorenofaria2305]

Thank you for this!!! You saved me hahahahaha

[@sidhartan]

awesome explanation

[@moi984]

1. What is i have blanks in my keyword list? 2. What about if i have "sign" or "tip" in my keyword list, and dont wont it to recognize "design" or "tips", (without being capital sensitive)? Maybe a part 2 video??? You saved my day by the way!!

[@souldigger9136]

Thankyou, this won't work if formatting is different right? for example its " adobe" instead of Adobe , then it wont pick.

[@PositivePeopleCommission300]

What if, i have a combination of keywords in a single cell and i want those keywords to be searched within a sentence(text)

[@smookiegook]

Yes, I have the same question as well. The keyword is actually multiple words. How do I do that..?

[@salimbenarab4897]

amazing, many thanks boss

[@thomasparenteau5452]

Any idea on how to do this exact same thing with power query ?

[@SNS1212]

Thank you so much for this!!!!!!!!!!!!

[@ghesoonkarim602]

Thank you 😊

[@emmyetyet3646]

I couldn't find a tutorial of this in Google Sheets 😢

[@muskanshrestha13]

Thankyou!!

[@FRANKWHITE1996]

Thanks for sharing.

[@abhijitchoudhury2178]

How to get the position of the search outcome

[@gmlo719]

What if Let's say one string fits two categories, and I also want them to be listed to both categories, how would I do that? Thanks

[@subuddhiba]

How to do this in Power Query ?

[@CASKB-b3c]

Sir is there any limitations of this, as some of cells are not accepting the data they are just providing "0"

[@saravanakarthikmunusamy9472]

It’s working for just the first string of text and then resulting 0 for the rest. Looks the array value is not starting from beginning for the 2nd record and further. Could anyone help?

[@miko6464]

I am having the same issue. It's because when I drag down, rather than using the original reference table cells, it uses those cells but down one line, and so on. I havent figured out how to fix this. Did you figure it out??

[@miko6464]

Found my issue! See 5.52 in the video. I had missed the dollar signs before certain reference cells. Those dollar signs make those cells an "absolute" reference cells, meaning they will not change when dragged. Without the dollar signs, that are relative reference cells, so will change when dragged.

[@PositivePeopleCommission300]

Hats off!

[@RusticPickle24]

Thank you for the video! However, is there a way to do this with multiple keywords in a cell for instance Photoshop,After Effects, and Premier in one cell with the adobe category?

[@marksargent3342]

Respect!! :-)

[@SLHomie]

I did exactly as you have it.. but once I put in the MATCH function =Match(TRUE,ISNUMBER(Search(Array,Cell,)),0) ... i get the #N/A error Update: I downloaded your example file... and it breaks as well and your cells end up as '#N/A'

[@SLHomie]

Crlt+Shift+Enter ... that's the key here... I didn't realize it till now.

[@stephfuller4993]

@@SLHomie I had the same problem but can't resolve it. Not sure if it's to do with being on a Mac... command + return didn't work for me. any chance you can elaborate?

[@chowayutdadyicekhorani1860]

​@@SLHomiefinally must be {=index($i$3:$i$9,match(true,isnumber(search($h$3:$h$9,b3)),0))}

[@MohdSaifoulAzuan]

Thank ....

[@ascarius1282]

Doesnt work for me, always get the erorr to few arguments

[@coosack398]

Thank you so much. I finally found the right video after 10 hours of Googling!😄

[@catherinepowell216]

Thank you Chester!