IF function using matrix entries? HELP

[ph282]

Hey guys, I am having loads of trouble editing my spreadsheet and it seems to be taking a really long time (over 20,000 entries)...

I have some data for over 500 companies (1990-2015) and they all have different currency units which i need to convert (into EUR). It looks something like this



[TABLE="width: 200"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Comp[/TD]
[TD]Curr[/TD]
[TD]Div[/TD]
[TD]Rep[/TD]
[/TR]
[TR]
[TD]1990[/TD]
[TD]x[/TD]
[TD]CAD[/TD]
[TD]40[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]1991[/TD]
[TD]x[/TD]
[TD]CAD[/TD]
[TD]25[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]x[/TD]
[TD]CAD[/TD]
[TD]13[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]1990[/TD]
[TD]y[/TD]
[TD]USD[/TD]
[TD]11[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1991[/TD]
[TD]y[/TD]
[TD]USD[/TD]
[TD]43[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]y[/TD]
[TD]USD[/TD]
[TD]13[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]1990[/TD]
[TD]z[/TD]
[TD]ATS[/TD]
[TD]23[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1991[/TD]
[TD]z[/TD]
[TD]ATS[/TD]
[TD]45[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]z[/TD]
[TD]ATS[/TD]
[TD]34[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1990[/TD]
[TD]a[/TD]
[TD]BEF[/TD]
[TD]23[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
</tbody>[/TABLE]



I then have created a matrix (26,45) of all the historical exchange rates:

AED ATS AUD BEF BRL CAD CHF CLP*ZWD
1990
1991
1992
1993
1994
1995
*
2015

What I need is a formula that can recognise the units the companies 'dividends' and 'repurchases' is in and then divide by the correct exchange rate (that is by the correct entry in the matrix)?