$\backslash$table$[[$Seattle$,$ Washington California$],[$Shipping Center Source Zip Code with Miles from Shipping Center to Destination:$]]$

Hint:

Use Min function to find the shortest distance

distance, use match to find the index; then use the index to find the

shipping center in the range A$1$:D

MinDistance$*$ Per Mile Shipping Charge; question $1$: Sheet $1$: An Air Compressor Sales Company has four shipping centers. It delivers the compressors to customers by truck.

The per mile shipping charge is $$3\mathrm{.}11$ with a minimum charge of $$75.$

For each customer, determine which Shipping Center has the shortest distance and then calculate the total shipping charge for each customer transaction.