$3\mathrm{.}5$ Use the HLOOKUP

function in cell $H3$ to calculate the product pricing based on the color and quantity of the billboards ordered.

a$.$ Product pricing can be referenced on the "Product Pricing" lookup table $($range P$3$:Q$12).$

b$.$ Use appropriate relative and absolute cell references.

c$.$ Note the third argument within the HLOOKUP function is the row$\_$index$\_$num. It specifies how many rows to go down within the matching column to find the right value to return as the function result. For each Order, the value specified as $\text{'}$#'Shipped in Column D is the desired Row$\_$index$\_$num for that order $($i$.$e$.,$ you should refer to the respective Column D cell for the third HLOOKUP argument$).$ The row$\_$index$\_$num argument will be a reference to a cell in column $D$ rather than a fixed number.