Forum Discussion
LMI Calc - Formula
Hi!
I am trying to build a simple Lenders Mortgage Insurance Calculator to use, I have made a table where the relevant brackets are in place. Ideally, the calculator would use the loan amount and LVR to find the right rate to use to calculate LMI. I cant seem to figure out how to write out this formula, i was looking at a VLookup function but that may be wrong. I have uploaded the file for reference
2 Replies
paddy_stewart1225 any luck with this one. I see that the reply worked but only for the first column. Thinking there may need to be an if in there somewhere as well.
That would require this formula in E22 of the attached file:
=VLOOKUP(E21,D3:I18,
MATCH(G20,D2:I2,1),
1)
