Dynamic Vlookup in Sharepoint folder

Hello,

Im searching for a formula which enables a Vlookup to different excel files.
The difficult part is that this info should come from another excel file, one excel file for each country. The excel file is located on Sharepoint, but for design of the formula this should not matter. The exact file path I can always change later.

See also the excel files attachted.
Example 1 -> the result page were the formula is required for
Example 2 > here the data should come from.

Please let me know if anything is unclear,

Thanks a lot in advance,

Vincent

Try

=VLOOKUP(C5,INDIRECT("'[" &B5 &".xlsx]Data'!$B$3:$C$100"),2,0)

so file would be A.xlsx i.e B5="A"

Hi John,

Thanks for your reply.

I have a small addtional question as I am having some problems with linking to the exact file.
In which part of the formula do I specify the file path?

In this case for example:
https://sharepoint.com/geographic/countries

Best regards,