It would be great to get some assistance with the following please.
In column A, I have currency code and columns B, C & D sales numbers. On a different worksheet, I have a currency conversion table. I would like to replace all the sales figures in columns B, C & D with the currency conversion based on the currency code in column A.
In the example below on worksheet 1, all the values for EUR would decrease by 25% to convert them all to USD and the USD line would remain the same.
For example:
Worksheet1:
Column A Column B Column C Column D
EUR $100 $250 $200
USD $100 $250 $200
EUR $100 $250 $200
Worksheet2:
Column A Rate
EUR 0.75
USD 1.00
Bookmarks