Pull keywords (countries) out of a column of headlines

[Rek88]

I have a large dataset which is a long list of newspaper headlines along with other irrelevant data. What I want to do is when a country is mentioned in a headline, be able to pick it out and dump it in the next cell along

So for example:
Column A contains a list of all the countries in Europe.
Column B contains all of the newspaper headlines.
Column C I want to show the country only, and if no country is found to be left blank.

Then I will count up the number of occurrences of each country.

Can anyone help, I’m guessing this is not possible with formulas and will require VBA?

 

[jtakw]

Hi,

No need for VBA:

Book1
	A	B	C
1	France	some text italy other text	Italy
2	Italy	text, other text, france, more text	France
3	Britain	just a lot of text without any country
4		britain and a bunch of text	Britain
Sheet670

Cell Formulas
Range	Formula
C1	=IFERROR(LOOKUP(2,1/SEARCH(A$1:A$3,B1),A$1:A$3),"")

Formula copied down.