Searching for keywords in a list?

Question

Visual Basic

Hey! Tell me, a script or something else, how can I massively search for phrases from the general list using a specific list of words, and not one by one?

Answer 1

When it comes to parsing key phrases, the most convenient option is KeyCollector.
Shows the frequency of queries by location, calculates the cost of a click, parses from the Google planner and four Yandex sources (search suggestions, wordstat tips, right and left wordstat columns).
You can group phrases, massively mark minus phrases, add minuses from the list of phrases.
I also add KeyAssort - it clusters phrases for Yandex and Google.
Both programs are paid, but payment is 1 time. I have been working for 2.5 years without complaints.
I tried free methods before - either confusingly or limited statistics, so a weak core comes out.
Minus in the programs - you need to delve into the settings.

Answer 2

yes, there is a column of words, you need to find in it the entire value from another column

Ivan Fadeev ,
1. Google "vp excel" ("vlookup excel")
2. perfect-excel.ru/publ/excel/makrosy_i_programmy_vb...

Answer 3

if both columns are only one word, then you can use the function "count if (range where we are looking for, search cell)" stretching the formula along the column with the words to search, if the function returns 0, then this word is not in the list, if > 0 then this word occurs as many times as there is a number.
Another variant with the same condition that only words in 2 lists are searched for.
list A and list B (what we are looking for).
=SUM(IF(A=TRANSP(B);1;0))
is possible without the transp function, but then the desired range must be horizontal
formula is entered as an array (ctrl + shift + enter)