Hello!

I have run into this problem. I tried to figure this out my own but after hour, I need to admit defeat...

Idea:
There is a text cell which contains string of text. I want to search this cell based on list what I have defined.
If there is a match, I want to return value - based on what it found.

To illustrate what I mean, I have created an example workbook. Here is though more explanation to avoid misunderstanding

I have list of search words and Column B is what I would like to return if that specific search word matches:

00listvalues.PNG

And here is the original data with comments, in column A I would like to have the formula where it would return country. "Desired outcome" is what should be correct, if I would perform this work manually.

00listvalues2.PNG

Attachment included:

Lookup.xlsx

Thank in advance for those who spend their time assisting me!