Calculator Table

Looking for some help creating an auto calculator. I have a table of data, the top row is for a term of say 36 months, 48 months, then I have a set dollar amount between 0-9999 and 10000 - 15000. I want to pull the rate based on the dollar amount and the term. Any ideas?

36 48
9999 0.022 0.033
10000 0.044 0.0555

Hi!

Create a table so that the leftmost column contains the lower bound of each
rate level.

A2 = Amount = 12500
B2 = Term = 36
C2 = formula to return the rate:

=INDEX(G2:H6,MATCH(A2,E2:E6),MATCH(B2,G1:H1))

Screencap:

http://img55.imageshack.us/img55/3065/table0ka.jpg

Biff

"R3FuSeR" <R3FuSeR.24xmcm_1142797203.2486@excelforum-nospam.com> wrote in
message news:R3FuSeR.24xmcm_1142797203.2486@excelforum-nospam.com...
>
> Looking for some help creating an auto calculator. I have a table of
> data, the top row is for a term of say 36 months, 48 months, then I
> have a set dollar amount between 0-9999 and 10000 - 15000. I want to
> pull the rate based on the dollar amount and the term. Any
> ideas?
>
> 36 48
> 9999 0.022 0.033
> 10000 0.044 0.0555
>
>
> --
> R3FuSeR
> ------------------------------------------------------------------------
> R3FuSeR's Profile:
> http://www.excelforum.com/member.php...o&userid=32614
> View this thread: http://www.excelforum.com/showthread...hreadid=524076
>