Assuming your data in Transport start from A1 (header). Thus your first
formula goes to D2. Further assuming that the Distances table is in
sheet Distances, columns A:B in the same workbook (create a new sheet
and copy if necessary). Then in D2:

=VLOOKUP(C2, Distances!A:B, 2, 0)

Copy down as far as necessary.

HTH
Kostis Vezerides