LMI Calc - Formula

[paddy_stewart1225]

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]

@paddy_stewart1225 

That would require this formula in E22 of the attached file: 

=VLOOKUP(E21,D3:I18,
MATCH(G20,D2:I2,1),
1)

[#3]

@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.