Index-match for data on mulitple rows

All,

I'm attempting to use an index-match formula to pull data from lower section 'Turck mileage by facility' to upper section 'truck mileage by unit #'. The mileage data occurs on multiple rows due to transfer of trucks amongst facilities.

Please refer to attached sheet.

Thanks in advance.

The easiest is to use =SUMIF()
Put in D6: =SUMIF($C$13:$C$16,$C6,D$13:D$16)
HTH
Ola