OK Folks, Monday morning and my brain is not functioning properly so I am
turning to you guys for help.

I have a table of exchange rates that looks something like this

EUR USD CHF
30/11/2008 1.2108 1.5396 1.8709
31/12/2008


The whole table has been named dtiExchangeRates.

Elsewhere I have date that looks like this

Joe Blogs EUR 1000 20/11/2008
Eric Sykes CHF 3000 25/11/2008

I want to put a formula in the fifth column which will calculate the
sterling equivalent of the amount in the third column by reference to the
appropriate currency. Thus the result in the fifth column would be 825.90
for Joe Blogs and 1,603.51 for Eric Sykes.

I assume that some kind of Index/Match combination would do it but my head
is hurting trying to figure it out. Any help would be much appreciated.

Many thanks in advance,

Andrew