I have a workbook where Worksheet1 has data with amounts paid in 3 different currencies, and I need a column to calculate the equivalent of the expense in a single currency. The workbook also contains Worksheet2 with rates of exchange which change on a daily basis. How can I find the corresponding date/currency/rate of exchange in Worksheet2 and calculate the USD equivalent if the amount paid was not in USD, and just copy the USD amount to the cell if it was paid in USD? The solution must be a formula, not a macro or VBA as they're not allowed where I work.
Attached is a spreadsheet with sample data.
Thank you very much.