$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 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

'A'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