Spreadsheet issue

[Don Niall]

Hi,

I am working with a large excel based spreadsheet that
has '000 entries. Column A is month, column B is currency
abbreviation (eg CAN = CANADA) and column C = appropriate
currency rate for month in question.
Is there a currency matrix table I can set up on a
seperate worksheet, whereby I enter the appropriate rate
for each month, and a lookup will then enter the relevant
rate into the actual data? The reason I require this is
often I may have to work with an 'old' currency rate (as
new monthly rates may not be released for whatever
reason) ... If I had such a matrix table, I would just
need to make the edit once and all entries in data are
updated ...

Don-

 

[Don Guillett]

Have a look in HELP index for vLOOKUP