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.

Regions (Desired Result)	Country
Eastern Europe, Western Europe, North America	Bulgaria, Romania, Netherlands, Russia, Canada, United States

<tbody>
</tbody>

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.