$1\mathrm{.}1$ Use the VLOOKUP function

$1\mathrm{.}2$ Copy your formula in cell

$1\mathrm{.}3$ Use the VLOOKUP function

in cell G$3)$ to calculate the delivery

price for order $1.$

a$.$ The delivery price can be

referenced on the "Delivery

Information" lookup table.

b$.$ Use appropriate relative and

absolute cell references.

$1\mathrm{.}4$ Copy your formula in cell

$1\mathrm{.}5$ Use the HLOOKUP function

$1\mathrm{.}6$ Copy your formula in cell

Conditional