Apr 30 2019 04:35 PM
I have a spreadsheet that updates the daily exchange rate to a given cell. I have a column of dates that I wish to have that given date equal that day's rate without changing the previous date's rates. I have tried IF AND formulas that return the correct info to that day's date but change all previous dates to "FALSE". Other VLOOKUP formulas return #NAME? or #VALUE!. Any help would be appreciated. Thank you
Apr 30 2019 04:44 PM
Apr 30 2019 06:54 PM
THank you for your interest in helping @Wyn Hopkins. I have attached the file. It is macro enabled MSO2016. I use this worksheet in other work books to update the current exchange rates for the date of a given transaction as the rates do change daily. The Exchange rate at the top will update automatically or when refresh external reference is selected. I have been updating the right column manual. I know this can be done automatically without changing/clearing the previous date's rates. Hope this helps to explain what I am trying to achieve.
May 01 2019 05:34 AM
If you are trying to keep a history of the rates on particular dates then you will need to use a macro to run a copy paste values routine.
I've fixed up a couple of the formula but I don't think you can do what you want to do using formula
May 01 2019 06:15 PM
May 02 2019 04:27 AM
Nov 06 2020 02:58 PM
Nov 08 2020 04:43 PM
@Dallen8028
This may be of interest to you https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338?WT.mc_id=M365...