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
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.