How to search multiple value?

Question

excel

In exel there is a search function for the word ctrl + f , this function searches for just one word. Question, I have a few words that I need to search for, let's say there is a table of keywords, and from it you need to select all the minus words from another table

Answer 1

1. Use a filter. There you can add to existing results: find "avito", then "pass" and mark "add to existing result"
2. Use a custom filter like "and", "or", "not", etc., but no more than 2x.
3. Use a keycollector (import the current list of negative keywords as phrases, or import into a "custom column") - there you can set unlimited filtering conditions, unlike step 2.