Spreadsheet: 879816d1727373820-hlookup-with-nested-if-gab
Sheet: Sheet1

 | Freight Costs
 | Shipping Class | AZ | WA | NV | UT | CA | MT | OR | CO | HI
 | Regular | 5 | 6 | 5 | 3 | 5 | 6 | 6 | 5 | 8
 | Express | 7.6 | 8.4 | 7.6 | 4.7 | 7.6 | 8.4 | 8.4 | 7.6 | 13.5
 | Overnite | 11.6 | 13.7 | 11.6 | 7.8 | 11.6 | 13.7 | 13.7 | 11.6 | 17.1
 | OrderID | Ship To | ProductID | Product Name | Value | Shipping Class | Insurance Cost | Freight Cost | Shipping Total |  | Insurance Cost
 | 1003 | AZ | 100 | QuickStove | 68.8 | Express | 2.5 |  |  |  | Shipment Value | Insurance Cost
 | 1004 | WA | 100 | QuickStove | 86 | Express | 2.5 |  |  |  | 0 | 0.5
 | 1007 | NV | 100 | QuickStove | 120.39 | Regular | 3 |  |  |  | 10 | 1
 | 1011 | UT | 100 | QuickStove | 120.39 | Express | 3 |  |  |  | 30 | 2
 | 1027 | CA | 100 | QuickStove | 17.55 | Overnite | 1 |  |  |  | 50 | 2.5
 | 1041 | MT | 102 | Replacement Fuel Cells | 4 | Overnite | 0.5 |  |  |  | 100 | 3
 | 1042 | CA | 104 | Quick Stove Can | 69.98 | Overnite | 2.5 |  |  |  | 200 | 4
 | 1050 | OR | 104 | Quick Stove Can | 274.32 | Overnite | 4 |  |  |  | 400 | 5
 | 1058 | UT | 104 | Quick Stove Can | 274.32 | Express | 4
 | 1059 | AZ | 102 | Replacement Fuel Cells | 15.68 | Regular | 1
 | 1060 | WA | 104 | Quick Stove Can | 69.98 | Overnite | 2.5
 | 1062 | UT | 102 | Replacement Fuel Cells | 60.8 | Regular | 2.5
 | 1073 | CO | 104 | Quick Stove Can | 34.99 | Overnite | 2
 | 1074 | CO | 102 | Replacement Fuel Cells | 19.6 | Overnite | 1
 | 1088 | WA | 102 | Replacement Fuel Cells | 4 | Overnite | 0.5
 | 1094 | NV | 102 | Replacement Fuel Cells | 8 | Express | 0.5
 | 1109 | HI | 102 | Replacement Fuel Cells | 8 | Express | 0.5
 | 1120 | OR | 102 | Replacement Fuel Cells | 38 | Express | 2
 | 1255 | OR | 106 | Stove In A Can | 34.99 | Overnite | 2
 | 1262 | UT | 106 | Stove In A Can | 102.87 | Regular | 3
 | 1265 | WA | 106 | Stove In A Can | 34.99 | Express | 2
 | 1267 | CA | 106 | Stove In A Can | 102.87 | Overnite | 3
 | 1268 | MT | 106 | Stove In A Can | 34.99 | Regular | 2
 | 1364 | AZ | 106 | Stove In A Can | 398.89 | Regular | 4
 | 1417 | UT | 108 | QuickStove Fuel Disk | 37.85 | Overnite | 2
 | 1629 | CA | 107 | SIAC Fuel Cell | 10 | Express | 1
 | 1635 | CO | 106 | Stove In A Can | 69.98 | Express | 2.5
 | 1661 | AZ | 107 | SIAC Fuel Cell | 47.5 | Regular | 2
 | 1666 | OR | 107 | SIAC Fuel Cell | 19.6 | Express | 1
 | 1677 | WA | 108 | QuickStove Fuel Disk | 31.54 | Express | 2
 | 1686 | CA | 101 | QuickStove Can | 19.95 | Overnite | 1
 | 1701 | CO | 101 | QuickStove Can | 19.95 | Overnite | 1
 | 1708 | AZ | 101 | QuickStove Can | 19.95 | Overnite | 1
 | 1712 | AZ | 108 | QuickStove Fuel Disk | 47.31 | Express | 2
 | 1718 | OR | 101 | QuickStove Can | 39.9 | Overnite | 2
 | 1720 | UT | 101 | QuickStove Can | 78.2 | Overnite | 2.5
 | 1725 | WA | 101 | QuickStove Can | 78.2 | Express | 2.5
 | 1733 | CA | 110 | [NAME] | 175.5 | Regular | 3
 | 1746 | CO | 110 | [NAME] | 87.75 | Express | 2.5
 | 1748 | NV | 101 | QuickStove Can | 78.2 | Overnite | 2.5
 | 1776 | MT | 101 | QuickStove Can | 78.2 | Overnite | 2.5
 | 1797 | WA | 114 | Cube Stove + 2 Fuel Disks | 49.9 | Express | 2
 | 1814 | AZ | 114 | Cube Stove + 2 Fuel Disks | 24.95 | Regular | 1
 | 1834 | CO | 113 | Firebox Stove w/ Fuel | 49.95 | Overnite | 2
 | 1835 | CA | 113 | Firebox Stove w/ Fuel | 49.95 | Overnite | 2
 | 1839 | CA | 114 | Cube Stove + 2 Fuel Disks | 49.9 | Express | 2
 | 1842 | MT | 108 | QuickStove Fuel Disk | 18.92 | Overnite | 1
 | 1873 | CA | 109 | Folding  Campfire Stove | 59.99 | Regular | 2.5
 | 1877 | CA | 121 | Firebox Master [NAME] | 144.98 | Overnite | 3
 | 1897 | NV | 118 | Firebox Deluxe [NAME] | 89.99 | Regular | 2.5
 | 1913 | AZ | 118 | Firebox Deluxe [NAME] | 89.99 | Regular | 2.5
 | 1923 | WA | 109 | Folding  Campfire Stove | 59.99 | Regular | 2.5
 | 1946 | WA | 118 | Firebox Deluxe [NAME] | 89.99 | Overnite | 2.5
 | 1964 | AZ | 109 | Folding  Campfire Stove | 59.99 | Express | 2.5
 | 1979 | HI | 118 | Firebox Deluxe [NAME] | 89.99 | Overnite | 2.5
 | 1982 | CA | 118 | Firebox Deluxe [NAME] | 89.99 | Overnite | 2.5
 | 1990 | CO | 109 | Folding  Campfire Stove | 59.99 | Regular | 2.5
 | 2000 | WA | 121 | Firebox Master [NAME] | 144.98 | Express | 3
 | 2031 | CA | 117 | Firebox Upgrade Kit | 69.96 | Overnite | 2.5
 | 2078 | AZ | 117 | Firebox Upgrade Kit | 34.98 | Overnite | 2
 | 2093 | AZ | 121 | Firebox Master [NAME] | 144.98 | Overnite | 3
 | 2136 | NV | 109 | Folding  Campfire Stove | 59.99 | Overnite | 2.5
 | 2146 | CO | 118 | Firebox Deluxe [NAME] | 89.99 | Regular | 2.5
 | 2168 | NV | 108 | QuickStove Fuel Disk | 31.54 | Regular | 2
 | 2198 | UT | 114 | Cube Stove + 2 Fuel Disks | 24.95 | Regular | 1
 | 2202 | AZ | 123 | [NAME] | 15.99 | Regular | 1
 | 2217 | WA | 117 | Firebox Upgrade Kit | 34.98 | Regular | 2
 | 2218 | OR | 118 | Firebox Deluxe [NAME] | 89.99 | Overnite | 2.5
 | 2249 | OR | 117 | Firebox Upgrade Kit | 34.98 | Regular | 2
 | 2258 | CA | 123 | [NAME] | 15.99 | Regular | 1
 | 2283 | UT | 118 | Firebox Deluxe [NAME] | 89.99 | Overnite | 2.5
 | 2319 | WA | 124 | The Ugly Bag - HD [NAME] | 9.99 | Express | 0.5
 | 2324 | UT | 121 | Firebox Master [NAME] | 144.98 | Regular | 3
 | 2328 | MT | 118 | Firebox Deluxe [NAME] | 89.99 | Express | 2.5
 | 2331 | UT | 109 | Folding  Campfire Stove | 59.99 | Regular | 2.5
 | 2353 | CA | 124 | The Ugly Bag - HD [NAME] | 19.98 | Express | 1
 | 2358 | HI | 109 | Folding  Campfire Stove | 59.99 | Express | 2.5
 | 2386 | CO | 123 | [NAME] | 15.99 | Regular | 1
 | 2393 | CO | 114 | Cube Stove + 2 Fuel Disks | 24.95 | Express | 1
 | 2417 | OR | 109 | Folding  Campfire Stove | 59.99 | Overnite | 2.5
 | 2419 | HI | 123 | [NAME] | 15.99 | Regular | 1
 | 2423 | AZ | 124 | The Ugly Bag - HD [NAME] | 29.37 | Overnite | 1
 | 2439 | UT | 117 | Firebox Upgrade Kit | 34.98 | Overnite | 2
 | 2513 | AZ | 125 | 3 Months Fuel  with Stove | 189.99 | Overnite | 3
 | 2521 | CA | 125 | 3 Months Fuel  with Stove | 189.99 | Express | 3
 | 2527 | CO | 117 | Firebox Upgrade Kit | 34.98 | Overnite | 2
 | 2605 | CO | 125 | 3 Months Fuel  with Stove | 189.99 | Express | 3
 | 2644 | WA | 128 | Heavy Duty [NAME] | 15.99 | Overnite | 1
 | 2653 | OR | 129 | Stainless Steel Cup Charger | 149.99 | Overnite | 3
 | 2714 | NV | 117 | Firebox Upgrade Kit | 34.98 | Overnite | 2
 | 2726 | CA | 127 | Stainless Steel Cooking Pot | 19.99 | Overnite | 1
 | 2779 | MT | 109 | Folding  Campfire Stove | 59.99 | Express | 2.5
 | 2829 | HI | 132 | Adjustable Fire Grate | 7.99 | Regular | 0.5
 | 2833 | OR | 132 | Adjustable Fire Grate | 7.99 | Regular | 0.5
 | 2837 | AZ | 127 | Stainless Steel Cooking Pot | 19.99 | Regular | 1
 | 2855 | AZ | 137 | QuickStove Fire Starter | 3.9 | Express | 0.5
 | 2859 | CA | 132 | Adjustable Fire Grate | 39.15 | Overnite | 2
 | 2865 | CA | 137 | QuickStove Fire Starter | 64.84 | Regular | 2.5
 | 2868 | NV | 132 | Adjustable Fire Grate | 7.99 | Regular | 0.5
 | 2887 | WA | 123 | [NAME] | 15.99 | Overnite | 1
 | 2889 | OR | 133 | Extended Grill Plate | 9.99 | Express | 0.5
 | 2896 | WA | 132 | Adjustable Fire Grate | 7.99 | Regular | 0.5
 | 2903 | WA | 134 | Set of 2 Fire Sticks | 5.99 | Overnite | 0.5
 | 2905 | WA | 139 | [NAME] | 3.99 | Overnite | 0.5
 | 2921 | AZ | 110 | [NAME] | 87.75 | Overnite | 2.5
 | 2928 | MT | 132 | Adjustable Fire Grate | 7.99 | Express | 0.5
 | 2932 | MT | 150 | [NAME] | 16.49 | Express | 1
 | 2938 | CA | 138 | Grill Plate | 7.99 | Overnite | 0.5
 | 2939 | CO | 132 | Adjustable Fire Grate | 7.99 | Overnite | 0.5
 | 2979 | OR | 124 | The Ugly Bag - HD [NAME] | 9.99 | Overnite | 0.5
 | 2999 | MT | 133 | Extended Grill Plate | 9.99 | Express | 0.5
 | 3005 | MT | 146 | Olicamp Space Saver Cup | 8.96 | Regular | 0.5
 | 3034 | MT | 121 | Firebox Master [NAME] | 144.98 | Express | 3
 | 3043 | UT | 123 | [NAME] | 15.99 | Regular | 1
 | 3049 | UT | 132 | Adjustable Fire Grate | 7.99 | Express | 0.5
 | 3069 | CA | 157 | Nalgene Cantene 32 oz | 11.49 | Overnite | 1
 | 3079 | CA | 145 | Cube Stove + 9 Fuel Disks | 35.99 | Express | 2
 | 3095 | OR | 134 | Set of 2 Fire Sticks | 11.98 | Express | 1
 | 3111 | AZ | 136 | Boil Plate | 7.99 | Express | 0.5
 | 3233 | CA | 144 | Trangia [NAME] | 14.99 | Regular | 1
 | 3246 | WA | 146 | Olicamp Space Saver Cup | 8.96 | Express | 0.5
 | 3265 | AZ | 144 | Trangia [NAME] | 14.99 | Overnite | 1
 | 3324 | UT | 124 | The Ugly Bag - HD [NAME] | 9.99 | Regular | 0.5
 | 3330 | WA | 163 | Klean Kanteen Wide 40 oz | 25.16 | Express | 1
 | 3345 | CA | 163 | Klean Kanteen Wide 40 oz | 25.16 | Overnite | 1
 | 3352 | CO | 161 | Olicamp Pot Lifter | 4.95 | Overnite | 0.5
 | 3357 | CA | 136 | Boil Plate | 7.99 | Express | 0.5
 | 3360 | CO | 134 | Set of 2 Fire Sticks | 5.99 | Regular | 0.5
 | 3374 | CA | 168 | [NAME] | 4.99 | Overnite | 0.5
 | 3377 | AZ | 150 | [NAME] | 16.49 | Regular | 1
 | 3381 | OR | 150 | [NAME] | 16.49 | Overnite | 1
 | 3394 | UT | 129 | Stainless Steel Cup Charger | 149.99 | Regular | 3
 | 3403 | CO | 128 | Heavy Duty [NAME] | 31.98 | Overnite | 2
 | 3404 | CA | 146 | Olicamp Space Saver Cup | 8.96 | Regular | 0.5
 | 3429 | OR | 171 | Power Bank with Flashlight | 14.99 | Regular | 1
 | 3430 | HI | 128 | Heavy Duty [NAME] | 31.98 | Overnite | 2
 | 3441 | HI | 121 | Firebox Master [NAME] | 144.98 | Express | 3
 | 3446 | HI | 133 | Extended Grill Plate | 9.99 | Overnite | 0.5
 | 3464 | OR | 127 | Stainless Steel Cooking Pot | 19.99 | Regular | 1
 | 3485 | AZ | 130 | Emergency [NAME] | 25 | Express | 1
 | 3539 | CA | 139 | [NAME] | 7.98 | Overnite | 0.5
 | 3546 | UT | 128 | Heavy Duty [NAME] | 15.99 | Overnite | 1
 | 3554 | HI | 134 | Set of 2 Fire Sticks | 5.99 | Regular | 0.5
 | 3585 | NV | 127 | Stainless Steel Cooking Pot | 19.99 | Overnite | 1
 | 3616 | CA | 175 | Folding [NAME] | 29.99 | Express | 1
 | 3618 | OR | 143 | [NAME] | 15.29 | Overnite | 1
 | 3653 | CA | 120 | Master [NAME] | 144.98 | Express | 3
 | 3663 | CA | 154 | Deluxe [NAME] | 89.99 | Express | 2.5
 | 3702 | CA | 171 | Power Bank with Flashlight | 14.99 | Overnite | 1
 | 3718 | CA | 176 | Firebox Accessory Kit | 31.48 | Express | 2
 | 3800 | MT | 168 | [NAME] | 4.99 | Express | 0.5