Table array

[SystemsAccountant]

Hi,

Below I have a table of exchange rates pertaining to different periods:

Please Login or Register  to view this content.

I've named the table "ExchangeRatesTable".

On a sheet I need to return the exchange rate where a the data qualifies in one of the above and also looks at the currency type, E.g.

On other worksheet:-
Cell A1 = Date = 31/1/07
Cell A2 = Currency = USD

Therefore in cell A3 I would need $1.79

Help greatly appreciated.

Thanks
Matt

[SystemsAccountant]

I think I have worked it out:-

Please Login or Register  to view this content.