Key word alert from sentences plus addendum

For this to happen, you will need to provide a listing of words and abbreviations that you wish to have identified. We are not mind readers nor horse afficianados that will know what words/abbreviations you wish to have flagged.

Additionally, please update your profile to identify which version of Excel you are using and your general location. Both of these items are important to knowing what will and will not work in your version of Excel.

Hi light,

Here is your answer. I needed to find a good website to find an answer at: https://exceljet.net/formula/cell-co...of-many-things
Find your file attached where I used a Dynamic Named Range of Problems on Sheet1 and a formula down a column to show your "C" or not. If you add any word to the ProblemList on Sheet1 (look in the Data Tab > Names Manager for the DNR) it should do what you requested.
Search using DNR List IsNumber SumProduct.xlsx

Edit:
You need to put this formula in E1 and pull it all the way down,

Formula:

Please Login or Register  to view this content.

To find a word in a sentence, use the Instr function within Visual Basic.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hey light,

After writing a lot of VBA code, I still the non-code answer better and here is why. If you shift your data by a few cells, your macro may no longer work. Why Because unless you are very careful with VBA code it is hard coded to places on your worksheet. I can't tell you how many apps I've written Excel where the end user wants to insert a column (or two) or move the lookup table to another sheet. When they do that the code breaks. If you use what I supplied above and insert columns, Excel knows and adjusts. Just my 2 cents.

Glad you got an answer you wanted.