Excel: Compare List Of Text Stings


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.

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


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 03, 2014.


For more resources for Microsoft Excel