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...
That would require this formula in E22 of the attached file:
=VLOOKUP(E21,D3:I18,
MATCH(G20,D2:I2,1),
1)