enter country by company name and company cost

Hello experts,

I need help to find formula or condition if or lookup to put Country by company name and Total amounts by its costs etc fee, learning & Core. desired tab highlighted in green Country on the basis of cell B6 which is company name. Country details and company names are in sheet/tab called * countries details*
example as Montes del plata company (dummy name) is in Uruguay and it has cost of learning, fee & Core.

Please fee free to question anything regarding my request. Appreciate your response.

Thanks in advance for help

Hi

Put into C8:

Formula:

Please Login or Register  to view this content.

I've added "*" just in case because for ex. Imatra exists as ', Imatra on Countries details.
If you clean a bit data in in col. D on Countries details, you can rid it of.