$3\mathrm{.}0$

ally aleas you ilau piunienis

with.

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

$1\mathrm{.}2$ Copy your formula i 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

in cell $H3$ to calculate the product

pricing based on the color and

quantity of the b