Hello!
Thanks you for providing these formulas ( https://www.myonlinetraininghub.com/excel-search-string-for-a-list-of-words)!! Unfortunately, I can't get them to work 🙁 . I downloaded the example file provided on your site and tried each formula provided with no luck and not sure what I am doing wrong. Could you please take a look at my attached file and let me know what I am doing wrong?
Column J is where I placed the code you provided. Column "X" is where I have the "List". Column D is the column I want to search for the words in the list
Thanks in advance for all your help!!
Change the named range "List" to be X2:X10. I.e. do NOT include empty cells and it shall work. Wrap the formula in IFERROR if want to avoid the #NUM! error.
Hello Riny,
Thanks for your reply. I tried doing that and it didn't work so not sure what I am missing?? Could you please adjust the spreadsheet and send it back so I can see what you are doing to make it work? BTW, you'll want to look at the sheet labeled "June" for where I placed the code.
Thanks for all your help Riny!!
Please have a look at the attached file. It seems to work for me.
That worked perfectly and can totally see what I was doing wrong.
Thanks a ton Riny!
