Hi,

I am using an Index Match formula to determine a charge from a table.

The criteria are Currency and Number of days. I dont fully understand the function and so am having trouble in correcting it as it is producing unexpected results.

The formula is INDEX('Charges Table'!$C$2:$R$13,MATCH(P79+1,'Charges Table'!$B$2:$B$13,1),MATCH(G79,'Charges Table'!$C$1:$R$1,0))

I have a number of days of 48 and this should return a charge of 3.5, being in the range more than 8 and less than 183 but it is returning 3.06

The attached table explains it better than i ever could in words!

What i need is a formula that can determine if the number of days is less than a number but greater than another.

7 DAYS 8< 3.06

8 DAYS TO

6 Months 183< 3.5

Perhaps someone could help me out by taking a look and give me an idea of what i need to do to correct the formula.

Thanks in advance for your time.

Neil