Search for string within a table and all rows that contain the string

Hello,
I have a table full of information that I would like to search by keyword. I don't know if it is possible, but I would prefer to search by multiple keywords and if any of them are found in the cell the row is returned to a new table or the original table can be filtered by the results. The columns of interest are E&F. If the keywords are found in cells from E or F I want to keep the entire row. For my application the keywords will only be part of the text string in each cell (i.e. if the keyword is "truck" the cell may contain "The blue truck was nice.").

Any help would be greatly appreciated. I have searched online for solutions and tried multiple methods, but cannot get anything to work correctly.

Attached is an example file to help show what I am trying to do.

If you undo the "Merge & Center" in your Search Terms, Use "Center Across Selection" instead, you could try this.

Please Login or Register  to view this content.