Lookup Functions Use the HLOOKUP function to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range ES: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 in cell H11 to calculate freight cost based on the shipping class and state 0 Cost Quickstove has an agreement with shippers for a fixed rate that is determined by destination state and service level [regular, express or CA MT 6 $ 5.00 $ 6.00 $ 500 S 3.00 5.00 S 6.00 $ 6.00 $ 5.00 $ 800 Express 760 840 7.60 S 4.70 7.60 $ 8.40 $ 8.40 7.60 13.50 Overnite S 1160 5 13.70 1160 780 1160 S 13.70 S 1370 1160 17.10 o OrderlD Ship To ProductiD Cost Freight Cost Shipment Insurance 1003 AZ 1004 WA 100 QuickStove 68.80 Express 2.50 VALUE VALUE 100 QuickStove 120.39 Regular S $10 S 1.00 5.00 S 8.00 17.55 Overnite 100$ 5.00$ 6.00 $ 4.00 Overnite os0 S 5.00 S 550 $6998 Overnite 250 5.00 750 274.32 Overnite 4.00 S 500 900 4.00 5.00 9.00 s 15.68 Regular 1.00 5,00 600 69.98 Overnite $ 2.50$5.00 $ 750 S 60.80 Regular 2.50 S 5.00 7.50 $ 34.99 Overnite 2.00S.00S 700 $ 50 $ 250 5 100 3.00 1027 CA 102 Replacement Fuel Cels 104 Quick Stove Can 104 Quick Stove Catn 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Carn 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Ceills 102 Replacement Fuel Cells 102 Replacement Fuel Cells 400 5 5.00 5 274 32 Express 1059 AZ 1060 WA 19.60 Overnite 1.00 8.00 ExpressS o.S0 500 550 38.00 Express S 2.00 5.00 $ 7.00 106 Stove In A 106 Stove In A Can 106 Stove In A Can 106 Stove in A Can 106 Stove In A Can 1262 UT 5.00 $ 7.00 102.87 Overnite S 300 S 5.00 5 800 S 39889 Regular S4.00S5.00 $ 9.00 3785 Overnite 200 00 $ 700 10.00 Express1.00S 5.00 S6.00 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove in A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can s 1995 Overnite S 1.00$ 5.00$ 6.00