SUMPRODUCT, multiple criteria including ranges that are listed horozontally

Hi guys,

Please see attached workbook (hopefully it attached ok)

I am looking to return a rate from a table based on 4 criteria

1. Freight type = B2 (vertical range A4:A22)
2. Trailer/Deck (qty) = C2 (horozontal range with duplicate values B11:AG11)
3. KMS travelled >= to A2 (horozontal range with duplicate values B12;AG12)
4. KMS travelled <= to A2 (horozontal range with duplicate values B13;AG14)

Value returned should be $4.60

I can see why this might not work with the kms qty range (horizontal and containing duplicates for each iteration of trailer & deck qty). Any advice on formula corrections or table reformat would be much appreciated, cheers.