Hi,

I am trying to write a formula using Index and Match functions to find the cost based on the type of the vehicle, Sale Price and duration in months.

The problem I am having is there is a range of sale Price.
If the type of vehicle is New,sale price is less than 20000 and term is 48 months then the Cost is $572.
And i don't know how to include the range values in the formula.

Right now the formula I am using is {=INDEX(J8:L19,MATCH(1,(K8:K11=C11)*(J8:J19=C9),0) ,3)}. But with this it is only looking for the specific value, not the range of values.

Any help is greatly appreciated.

Thanks,


Mismag

Attached Images

Capture.JPG (92.9 KB, 28 views)