Unstructured Addresses and Countries

[GrimGrin]

I have a column with full international addresses with no separators (commas or semicolons). I need to search each cell for a country name and put it in the cell next to it.

I've tried to use the search function and it works with one country but when I introduce the full country list, I get a #value ! Error.

This is my first post here. I really appreciate any assistance!

 

[RoryA]

Welcome to the forum.

Assuming youyr text is in A2, and the country list is in D1:D10, you could use:

=LOOKUP(1E+100,MATCH("*"&$D$1:$D$10&"*",A2,0),$D$1:$D$10)

and copy down.