Formula for (country in region)

[bell1958]

I build a master table of countries with all of the corresponding regions and then I build a VLOOKUP to retrieve the values which is working great. I'm having a problem where multiple countries are listed in a cell where I have the region as "multiple region" since it's more that one country. In the master table how do I list the countries for that one cell where I have the region as "multiple region"?

The 1st screenshot master spread sheet with the data where you can see it auto filled in the region with single countries listed but for Indonesia, Kenya it has #N/A. The 2nd screen shot is the master table countries and corresponding regions. In the master table where it's highlighted in yellow opposite Multi-Region how do I set up the countries so it can auto fill "Multi-Region instead of #N/A in the master spread sheet?

Formula for (country in region) - Album on Imgur

 

[Taul]

Hi and welcome to the forum,
One way is to treat the items that have more than one region as an error, something like this:-

=IFERROR(VLOOKUP(A3,$A$16:$B$19,2,FALSE),"Multi-Region")

They may be a better way to do this and hopefully someone else will suggest a better way.

HTH

Paul.