Compare List Of Text Stings

[jasbir]

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

<tbody>
</tbody>

 

[jasbir]

Aladin- good news- I finally got it to work!. I have never used the Name box so forgive my limited experience with excel. So far I have results COL showing one of the matching terms showing.

 

[Aladin Akyurek]

Aladin- good news- I finally got it to work!. I have never used the Name box so forgive my limited experience with excel. So far I have results COL showing one of the matching terms showing.

Right. As advertised. If you want all of the keywords figuring in a target string, a different approach using a function in VBA is needed.

 

[jasbir]

Thanks. I am not sure I can use VBA code at this time so I will hold off.

 

[Aladin Akyurek]

Thanks. I am not sure I can use VBA code at this time so I will hold off.

OK. You are welcome by the way.

 

[jasbir]

You are a genius! I have been looking for this solution on google for days and you managed to solved this fairly quick.