Hi

Why make life difficult for yourself by continuing with a two column unsorted table?
You could easily extract a list of countries belonging to each Continent to create 5 individual tables.
Then you can achieve what you want very easily as described in a Tutorial I posted here
http://www.contextures.com/exceldata...sindirect.html