$1\mathrm{.}5$ Use the HLOOKUPfunction in cell H$3$ to calculate the product pricing based on the color and quantity of the billboards ordered.Product pricing can be referenced on the "Product Pricing" lookup table $($range P$3$:Q$12)).$Use appropriate relative and absolute cell references.Note the third argument within the HOOKUP 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 #'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 fixednumber.