I am confused on how to use the formula HLOOKUP on Excel to calculate the shipping costs for this problem.

quantity). Copy the formula into cells 08:011. 5. In cell D14 of the Orders worksheet, calculate the total cost of the order. 6. In cell D15 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 C2, C3, and C4 to retrieve the answer. For the rownumber argument of the HLOOKUP, use C3 + 1 alculate the handling cost Be certain to account for the E N 3 CO 8 B C D 1 Golf Products Order Form Shipping weight 175 3 Region number 1 4 Shipping Method 3 5 6 Item# Quantity Description Total 7 1 10 Titanium Driver - Men $ 3,250 8 7 2 Stainless Steel Fairway - Women $ 400 9 4 8 Fairway Woods - Men 1,592 10 15 2 Package - Men 1,350 11 5 20 Hybrid Woods - Men $ 1,199 12 13 14 Total Order $ 7,791.00 15 Shipping 16 Handling $ 17 Discount 18 19 Grand Total 20 21 29 Allell D3 X for 1.22 E 1 2 3 4 5 6 Region 1 $ 2 $ 3 $ 4 $ 5 $ B C D Shipping Method 1 2 3 0.09 $ 0.10 $ 1.22 0.16 $ 0.11 $ 1.62 0.20 $ 0.12 $ 1.70 0.24 $ 0.14 $ 1.82 0.37 $ 0.33 $ 2.84 4 NA NA $ 0.16 $ 0.16 $ 0.28 7 8 9 10