$6.$ In cell D$15$ of the Orders worksheet, calculate the total shipping charge for this order based on three variables: the ship$-$to region, the total weight, and the method of shipping.

a$.$ HINT: This will require a HLOOKUP and cells C$2,$ C$3,$ and C$4$ to retrieve the answer. For the rownumber argument of the HLOOKUP, use C$3+1$