I have a list of keywords in an Excel file.
I need to create a workflow that uses the list of keywords to search through a large table and highlight every record in the table that mentions any of the keywords.
| Keywords |
| Machine Learning |
| Greenhouse |
Sample Data Set
| Project ID | Project Name |
| 1001 | Coca Cola Pursuit |
| 1002 | GNC Machine Learning Pursuit |
| 1003 | Disney Greenhouse Machine Learning Deal |
| 1004 | Yeti Machine Learning Deal |
| 1005 | HP Record |
Desired Output
| Project ID | Project Name | Matches |
| 1001 | Coca Cola Pursuit | NA |
| 1002 | GNC Machine Learning Pursuit | Machine Learning |
| 1003 | Disney Greenhouse Machine Learning Deal | Greenhouse, Machine Learning |
| 1004 | Yeti Machine Learning Deal | Machine Learning |
I've tried to use the find and Replace tool but this gets tricky when when one record matches more than one keyword.
Any help would be greatly appreciated!
