What is the best way to search for the presence of a list of text strings?
Attached is a sample file.
The "Data records" worksheet contains a data column called "Title" and another column called, "Filter check".
The "Current filters list" worksheet contains in the "Filters List" column a list of text strings. This list is likely to grow over time.
I'd like to know the best way to check each Title field in the Data records worksheet for the presence of any of the text strings in the Current filters list worksheet's Filters List.
For example, the first Filters List value is "happy cow". Since *happy cow* is not contained in any of the Title values in the Data records worksheet, it should not get a value in the Filter check column. However, the 4th and 5th records in the Data records worksheet should get a "Yes" in the Filter check column, because they both do contain text strings that are included in the Current filters list worksheet's Filters List column.
I've used SEARCH to search for single strings within strings, but I don't know the best way to handle this situation. My actual list of filters is about 15 - 20 different text strings.
Can someone help me with this?
Bookmarks