Spreadsheet issue

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

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-
 
Back
Top