Question

Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the ÒValueÓ in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately. please provide formula

2When shipping products two major costs are incurred: the cost of insuring 3 the item and theactual freight cost. Insuranceis dependent on thevalue of 4 the shipment 5 Quickstove has an agreement with shippers for a fixed rate that is 6 determined by destination state and service level (regular, express orR Freight Cost CA OR Regular5.006.005.00 3.00 5.006.006.00$ 5.00$8.00 Express 7.60$8.40 7.60 4.70 7.60 8.40 $ 8.40 7.60 13.50 Overnite 11.60 S13.70 $ 11.60 $ 7.80 $ 11.60 $13.70 $ 13.70 $11.60 $ 17.10 overnite Shipping Insurance Shipping nsurance Cost 101 OrderID ShipTo ProductID Product Name Value Cost Freight Cost Total Shipment Insurance 1003 AZ 68.80 Express 86.00 Express 120.39 Regular $120.39 Express $17.55 Overnite 4.00 Overnite 69.98 Overnite 100 QuickStove 1 -_-- 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick StoveCan_ 102Replaement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells Value 12__1004)WA100 QuickStove 1007 NV 1011 1027CA 1041 MT 10421 CA $10 1.00 $302.00 $50 2.50 $ 100 3.00 200 4.00 400 5.00 18 1050 OR $274.32 Overnite 1058 UT 1059AZ 1060WA 1062 1073 1074] CCo $274.32 Express 15.68 Regular $ 69.98 Overnite 60.80 Regular 34.99 Overnite S 19.60 Overnite 4.00 Overnite $8.00 Express $8.00 Express 38.00 Express S 34.99 Overnite 102.87 Regular 24 25 1088WA102)Replacement Fuel Cells 1094 i NV ! 1109 1120OR 1255 OR 1262 UT 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can HI 28 30

Answer 1

the formaule that we need to use here in Cell G11 is below
=vlookup(E11,$k$11:$L$18,2,true)
same formuale above can be dragged for all cells in the column G11 to G30
the formuale looks for appropriate cost and if value works like a range and if it is 68.8 then it is between 50 and 100 of shippment value and answer returned is 2.5