help for an excel formula

[delvillardennis]

I need to compute the finance charges by selecting the applicable interest rate within the covered months. Please help for the excel formula to use in column D using the interest rate in column k satisfying the criteria of column A and B. See my sample excel in the link below.


https://www.dropbox.com/s/lpqbm1s5anzrs02/sample%20finance%20charges.xlsx


Thanks in advance!

 

[nazmul_muneer]

Dear delvillardennis

Type the formula in D9


=VLOOKUP(B9,$H$3:$J$9,3,TRUE)


You may copy the formula and paste in D9 in your sheet


Regards


Muneer

 

[delvillardennis]

Dear nazmul_muneer,


It works fine. Thanks for the help!


BR/delvillardennis

 

[nazmul_muneer]

HAPPY to help you!

 

[sdey73]

@nazmul_muneer


are you from vodafone???????


regards