Hi,

I have a rate chart that displays zones in the x axis and weights in the y axis with the rates in between.

I have a list of values that i need to work out the rates based on their weights and retrospective zones.

I was hoping to use something along these lines but it's not quite correct- 
=INDEX(rates!$B$13:$M$55,MATCH(Analysis!B2&Analysis!$C$2,rates!$B$12:$M$12&rates!$A$13:$A$55,0))
Ideally, I need an exact match on the zone and a greater than match on the weights. I figured out a slow way to do this with Vlookups and splitting the values into the zones and calculating the 12 zones individually, but this is time consuming.

Any help would be much appreciated.RatesSheet.xlsx