Return multiple text criteria based on multiple wildcard searches

[Country_Calc]

I am trying to return regions based on list of country names. There are many examples out there, but all I have found involve returning a single text value based on a single country. My data is all grouped together.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Regions (Desired Result)[/TD]
[TD]Country[/TD]
[/TR]
[TR]
[TD]Eastern Europe, Western Europe, North America[/TD]
[TD]Bulgaria, Romania, Netherlands, Russia, Canada, United States[/TD]
[/TR]
</tbody>[/TABLE]

Most examples recommend using vlookup but I think that only works with 1 country.

All I can think of is a really complicated IF statement.

I only want to return 1 instance of multiple countries fall with its category.

If anyone has any suggestions I would really appreciate it.

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,SEARCH(INDEX(Table,0,1),$A2),INDEX(Table,0,2))

Table is a 2-column which looks like:

Eastern Europe, Bulgaria
Eastern Europe, Romania
Western Europe, Netherlands
...

A2 is a sring which presumbably contains a country name.