Find multiple words from one text column in another one!

Hi guys!!

I hope someone can help me solve this problem!
Basically I have 2 columns of text!!
On column A i have vitamin Names up to 40000 or more, this number can change so I cant tell the exact number!
On column B i have new researched vitamins (newer vitamins, under FDA testing bla bla) also up to a few thousand numbers!

So what i want to do is, search every word from column B (one by one) in column A, and make something to report back to me, or catch my eye for the words that are found in the two columns! (the best would be if the duplicate vitamin text can be copied to a new sheet)!

I'm interested in the words that are found in both columns! Those are important for me!

Thanks
All the best

Hi and welcome to the forum.

One way, could be this.

In your new Sheet, let's say in A1, put this formula and copy down.

=IF(COUNTIF(A:A,B1)>0,B1,"")

Is this, works for you?