10 10 11 On the Transactions worksheet, in cell 110, replace the static value by entering a VLOOKUP function to retrieve the Item's price from the Product List table and then multiply it by the quantity to calculate the gross revenue. Use the fill handle to copy the formula down through 130. On the Transactions worksheet, in cell K10, replace the static value by entering a HLOOKUP function to retrieve the discount value from the range B4:D6 based on the coupon code used in the transaction. Use the fill handle to copy the formula down through K30.