$3\mathrm{.}2$ Calculate freight cost based on the shipping class and state to which the shipment is going.

a$.$ Place your calculation for the first order in cell $(19).$

b$.$ Use the HLOOKUP function.

c$.$ Freight Cost can be referenced on the "Freight Cost" lookup table $($range $($C$3$:K$6)).$

d$.$ Hint: You will need to use a nested IF function within the HLOOKUP function to determine the appropriate row.

e$.$ Be sure to use appropriate relative and absolute cell references.

f$.$ Reuse your formula in cell $(19)$ to complete the "Freight Cost" column of the table.