Lookup with multiple input values and multiple results in one column

[Riesenrind]

Hi,

I have a master data set like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Region
[/TD]
[TD]Country[/TD]
[/TR]
[TR]
[TD]EU[/TD]
[TD]France[/TD]
[/TR]
[TR]
[TD]EU[/TD]
[TD]Germany[/TD]
[/TR]
[TR]
[TD]LATAM[/TD]
[TD]Mexico
[/TD]
[/TR]
[TR]
[TD]LATAM[/TD]
[TD]Bolivia[/TD]
[/TR]
[TR]
[TD]LATAM[/TD]
[TD]Columbia[/TD]
[/TR]
[TR]
[TD]APAC[/TD]
[TD]China[/TD]
[/TR]
[TR]
[TD]APAC[/TD]
[TD]India[/TD]
[/TR]
[TR]
[TD]AFRICA[/TD]
[TD]Egypt[/TD]
[/TR]
[TR]
[TD]AFRICA[/TD]
[TD]Libya[/TD]
[/TR]
</tbody>[/TABLE]


Now, I have a second table with a subset of regions, and I need to populate a 2nd column with the countries in those regions

[TABLE="width: 300"]
<tbody>[TR]
[TD]Lookup input[/TD]
[TD]Lookup output which I need[/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Country[/TD]
[/TR]
[TR]
[TD]EU[/TD]
[TD]France[/TD]
[/TR]
[TR]
[TD]AFRICA[/TD]
[TD]Germany[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Egypt[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Libya[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Ideally, I am looking for a matrix formula, not a macro.

I have trawled this forum and can't find any solution.
Can you help?

Andrew