Hi! I wasn´t able to find a solution for this.
To explain it as simple as posible, I have 2 tables:
Table 1 - I have US dollar exchange rates for every business day
Column A - Date
Column B - USD exchange rate
Table 2 - I have transactions
Column C - Transaction date
Column D - USD exchange rate
So in column D I have a lookup, where I search for USD exchange rate in Table 1, for the date in Column C. That is easy to do.
The problem is when the transaction occurs on a non-business day, like weekend.
So in excel, I had a vlookup where the last parameter was TRUE, so when the formula didn´t find the exact date on Table 1, it will return the nearest match (less than the date it was searching).
So if the Transaction date is 6 July 2019 (saturday) for example, it will not find it on Table 1, so it will return the exchange rate of 5 July 2019.
Is something like this possible on Coda?