vlookup and calculations

Column H(product cost) formula. Calculated from the Quantity and SKU in column C. Example 2-799600832622 would be two units of 799600832622. The cost of the item can be found in the lookup table by searching columns B or C or D for the SKU. When a match is found the value is multiplied by the quantity of items sold. Example 799600832622 can be found on row 99 in the lookup table. The cost per unit is $1.94. Our example of 2-799600832622 means the customer ordered 2 of this item so the total cost(H) is $3.88. Another example. 1-857206008022, 1-promotional-2 this means the customer ordered 1 each of 857206008022 and promotional-2. The total cost(H) for both items is $4.06 (3.50 + .56). IF ONE OR MORE ITEMS CANNOT BE FOUND then the field is left blank for manual review. Column I (packing cost) formula. Very similar to the above Each SKU is assigned a gallonage value. This value can be pulled from column F in the lookup table. The gallonage of the item can be found in the lookup table by searching columns B or C or D for the SKU. Example 799600832622 has a gallonage of .5. If the customer ordered 2-799600832622 then the total gallonage for that order would be 1.0. If the customer ordered 1-857206008022, 1-promotional-2 the total gallonage for that order would be 3.5. 1-857206008022 = 3.5 gallons and 1-promotional-2 = 0 gallons. We SUM the total gallonage for the order and reference sheet 2 in the lookup table. 3.5 gallons would have a packing cost of 1.32. The total gallonage for each order needs to be calculated then assigned a price and placed in column I. We have several tiers of gallons prices. If an order is 4.5 gallons it will be assigned 7 gallons value. If exactly 3.5 gallons it will be assigned 3.5 gallons. If its 2.01 gallons it will be assigned 3.5 gallons. It always rounds up to the next value if an exact gallonage is not matched.