Listing GDPgrowth % to correspong country and year

[dbven]

Hi,

I have a problem listing the GDP growth percentages to the corresponding companies with country codes and the right year.
The formula to use is with INDEX and MATCH but i cant figure it out.
Here is an example of a larger database.
In 1 sheet i have the companies with country codes and in the other sheet the country codes linked to the GDP growth rates.

Any help please?
Thnx!

[JeteMc]

The problem is that the years in row 4 of the data sheet are entered as text. Simply input them a "General" and then apply your INDEX/MATCH formula such as

=INDEX(Data!$E$5:$BH$48,MATCH(C2,Data!$B$5:$B$48,0),MATCH(D2,Data!$E$4:$BH$4,0))

in sheet 1 D2 and down.
Let me know if you have any questions.