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.