Lookup Functions Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references. Hint: You will need to use a function within the HLOOKUP function to determine the appropriate When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment Quickstove has an agreement with shippers for a fixed rate that is determined by destination state and service level (regular, express or Regular $ .006.00 S 5.00 $ 3.00 $ 5.00 $ 6.00 S 6.00 5.00 $ 8.00 Express S 7.60 8.40 7.60$ 470 S 7.60$ 8.40 $ 8.40 $ 7.60 $ 13.50 Overnite $ 1160 5 13.70 1160 S 7.80 1160 13.70 13.70 $ 1160 171 OrderlD Ship To ProductiD ValueClassCost :$6880 Express $ 2.50| #N/A 86.00 Express 2.50 S $120.39 Regular 3.00 S 120.39 Express 517.55 Overnite 1.00 s 4.00 Overnite 0S0S 5.00 69.98 Overnite 1004 WA 100 QuickStove 1027CA 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Car 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove in A Can 106 Stove in A Can 274.32 Overnite $ 400 5.00 S274.32 Express 4.00 15.68 Regular 1.00 15.68 Regular100 69.98 Overnite$ 2.50 $ 34.99 Overnite 2.00 $ 19.60 Overnite $ 1.00 S 1074 cO 1094 NV 120 OR 8.00 Express 0.so $ 8.00 Express 0.50 5.00 38.00 Express $ 34.99 Overnite 102.87 Regular $ 34.99 Express S 102.87 Overnite $ 34.99 Regular 200 3.00 2.00 $ 3.00 5.00 5.00 398.89 Regular 400 37.85 Overnite 2.00 08 QuickStove Fuel Disk 10.00 Express 69.98 Express s 47.50 Regular 107 SIAC Fuel Cell 106 Stove in A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 Quickstove Fuel Disk 101 QuickStove Can $ 5.00 5.00 5.00 19.95 Overnite$ 1.00 5.00 200 $19.60 Express $ 100 $31.54 Express $ 2.00 Lookup Functions Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references. Hint: You will need to use a function within the HLOOKUP function to determine the appropriate When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment Quickstove has an agreement with shippers for a fixed rate that is determined by destination state and service level (regular, express or Regular $ .006.00 S 5.00 $ 3.00 $ 5.00 $ 6.00 S 6.00 5.00 $ 8.00 Express S 7.60 8.40 7.60$ 470 S 7.60$ 8.40 $ 8.40 $ 7.60 $ 13.50 Overnite $ 1160 5 13.70 1160 S 7.80 1160 13.70 13.70 $ 1160 171 OrderlD Ship To ProductiD ValueClassCost :$6880 Express $ 2.50| #N/A 86.00 Express 2.50 S $120.39 Regular 3.00 S 120.39 Express 517.55 Overnite 1.00 s 4.00 Overnite 0S0S 5.00 69.98 Overnite 1004 WA 100 QuickStove 1027CA 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Car 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove in A Can 106 Stove in A Can 274.32 Overnite $ 400 5.00 S274.32 Express 4.00 15.68 Regular 1.00 15.68 Regular100 69.98 Overnite$ 2.50 $ 34.99 Overnite 2.00 $ 19.60 Overnite $ 1.00 S 1074 cO 1094 NV 120 OR 8.00 Express 0.so $ 8.00 Express 0.50 5.00 38.00 Express $ 34.99 Overnite 102.87 Regular $ 34.99 Express S 102.87 Overnite $ 34.99 Regular 200 3.00 2.00 $ 3.00 5.00 5.00 398.89 Regular 400 37.85 Overnite 2.00 08 QuickStove Fuel Disk 10.00 Express 69.98 Express s 47.50 Regular 107 SIAC Fuel Cell 106 Stove in A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 Quickstove Fuel Disk 101 QuickStove Can $ 5.00 5.00 5.00 19.95 Overnite$ 1.00 5.00 200 $19.60 Express $ 100 $31.54 Express $ 2.00
