Hello everyone - i am hoping someone can please help as this is a manual task so far and I am hoping it can be automated via formula or vba? I have a list of text search strings terms that I need to search in several columns for possible matches(hits). If match is found for any words on the search string then I would like to display them in a new COL so I can filter and take further actions. Here is my example below. Thank you.
<tbody>
</tbody>
List to search on | Search Strings | Hit |
Laptop must be retuned for repairs | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | laptop, repair |
Remove old ID from hard drive | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | remove, hard drive |
Bran07 was on Monitor List for remo | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | Monitor, Removal |
Dfat007 is on build report | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | build |
mobile device failur | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | mobile device |
wind2007/x4/4tran | laptop or desktop or "mobile device" or "Hard Drive" or "back up" or remove or removal or add or delete or monitor or build or repair or built | No Match |
<tbody>
</tbody>