I am preparing a freight sheet calculator for the buyers in the
company. When they put their Origin in sheet 1 and weight I would like
get the calculation from Sheet2 and bring the lowest cost with name of
the forwarder info to the sheet1 with carrier name and total cost. Can
anybody help me?
I do have the following info on Sheet1.
A B C
D
Origin Weight-Kg Forwarder Amount
Ningbo 55 Fedex 229.6


I do have the following info on Sheet2
A B C D
E F
Forwarder Origin 50kg 60kg fee Trucking
DHL Ningbo $3.60 $3.40 $25.00 $0.12
DHL Shanghai $3.50 $3.25 $25.00 $0.12
Fedex Shanghai $3.50 $3.25 $25.00 $0.25
Fedex Ningbo $3.60 $3.40 $25.00 $0.25


Thanks