How to calculate interest rates using VLOOKUP
We have chart with four rows which actually giving interest rate for 1yrs, 5yrs, 10yrs and 30 yrs. Now from that chart our target is to find out interest rate for any year given as input. Here is the chart given as input. B and C columns hold the given year and corresponding interest rate.[…]