Formula Lookup? (Making a Freight Calculator)

Hello All

Im fairly new to big formulations in excel

im trying to make a Freight Calculator

Where you will enter the Region(B1:F1) to a cell B11 and weight(A2:A7) into Cell B12 and it will return the rate(B2:F7) to Cell B13 multiplied by the weight

i work out how to do it with entering the Exact weight listed but if the weight is different it would return an error

so it need to find the rate between a certain range? im not sure if this makes sense

( See attached )

thanks for your help