Calculation using table and two variable

Ok, I hope I can explain this correctly...

I am trying to create a formula that populates a cell from a table. The table as below:

The outcome that I need is for the cell to calculate the following:
LMI = Loan value x (The percentage from the table using the LVR and total lending amount).



Please let me know if this makes no sense and thanks in advance for your help!

Alex

If you list the headers in your first table to show only the lower bounds:

e.g.


Then you can use a formula like:

=I2*INDEX($B$2:$C$4,MATCH(H2,$A$2:$A$4),MATCH(I2,$B$1:$C$1))

where your lower table is contatined in G1:J2, making I2 the first Loan Value, and H2 containing the LVR to look up.

You are truly an excel master. Thank you very much. It has worked perfectly!