$1\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 $.$

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

c$.$ Note the third argument within athe 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