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

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" wrote in
message ...

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