I have two worksheets in my workbook.
The first worksheet keeps track of the value of my mortgage/loan. The first column contains a date, the second contains the interest rate that pertains to that date. The rest of the columns contain things like interest accrued over the period, current value of the loan etc. The date in the first column pertains to an event, so it could be the day that I made a payment on the loan, or it could be a day that I increased the size of the loan.
In the second worksheet I have a list of historical interest rates. The first column contains the date at which a new interest rate came into effect and the second contains the interest rate itself.
Both sheets are ordered by date descending.
My question is, how do I pick the relevant interest rate from worksheet 2 to insert into the corresponding cell in worksheet 1?