MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 334
- Office Version
- 2013
- Platform
- Windows
I have a file that keeps track of a dollar debit and converts to a Kč (Koruna or crown) amount based on the exchange rate of the day the dollar amount was subtracted from my dollar account.
The row containing this data can be seen in the attached image.
I began this record-keeping in January of 2019 as you can see by the image. When the dollar debit is indicated by my dollar account statement then I post the amount, then the date of that amount and finally the USD to CZK exchange rate from that date. This exchange rate comes from a daily exchange rate file I keep as seen in the second image called CurrencyConversionRates.jpg.
What I would like to do is as follows:
When the dollar amounts are input (cells in column C & column G) then the Date is entered in the relevant cells in the Date Columns D & H causing a lookup formula to look at the relevant date in the CurrencyConversionRates file and return the USD to CZK exchange rate per that date.
I hope this is clear enough if not ask and I will provide whatever is needed to clarify.
Thanks for your help.
The row containing this data can be seen in the attached image.
I began this record-keeping in January of 2019 as you can see by the image. When the dollar debit is indicated by my dollar account statement then I post the amount, then the date of that amount and finally the USD to CZK exchange rate from that date. This exchange rate comes from a daily exchange rate file I keep as seen in the second image called CurrencyConversionRates.jpg.
What I would like to do is as follows:
When the dollar amounts are input (cells in column C & column G) then the Date is entered in the relevant cells in the Date Columns D & H causing a lookup formula to look at the relevant date in the CurrencyConversionRates file and return the USD to CZK exchange rate per that date.
I hope this is clear enough if not ask and I will provide whatever is needed to clarify.
Thanks for your help.