B2:M20 is the incentive matrix

A2:A20 is the tenure list

B1:M1 is the loan value list

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KDD" wrote in message
...
Thanks Bob.

Pardon my ignorance:

B2:M20 , A2:A20 and B1:M1 refer to which data?




--
KDDXB


"Bob Phillips" wrote:

=INDEX(B2:M20,MATCH(tenure,A2:A20,0),MATCH(loan,B1 :M1,0))

you might (will!) need to adjust to your data

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KDD" wrote in message
...
I have a sales incentive grid with tenure of loan on one axis & loan
size
on
another axis. For e.g., for a loan size between $6000 to $9999 at a
tenor
of
24 months, teh incentive payable is $24 whereas for a loan size
between
$10000 to &19999 at a tenor of 36 months, the incentive payable is
$65.
There
are a total of 7 loan bands on one axis and 5 tenor bands on the other
axis.

How do i create a formula so that excel picks the correct incentive
amount
depending upon the loan amount and tenor combination.

Its so confusing. Pls help..