Hello All,
This forum has helped me a lot to find solutions - however a bit stumped on this one.
Attached is a sheet with Country, Currency, effective date and operational rate.
I was looking to do an index match to find the exchange rate for a given currency and trade date (find the previous closest effective date - if this does not exist then find the closest date after the trade date. (Cells G5:I5)
I something like this formula to get the closest previous date - but it does not take into account the currency code:
=INDEX(E6:E19999, MATCH(MIN(IF(D6:D19999-H6<=0, D6:D19999-H6, "")), D6:D19999-H6, 0))
Thanks!
Bookmarks