Index and Match Function
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
|