to find the lowest shipping cost per unit.

$8.$ In cell $C14,$ identify the vendor with the lowest cost per unit by creating a formula using the YLookUP. function to look up the value from cell B$12($the lowest vendor cost$)$ in the range B$5$:C$8($the vendor cost per unit table$),$ return the name of the vendor $($column $2),$ and specify an exact match. Copy the formula to cell F$14$ to identify the shipper with the lowest cost per unit.