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 row.
Solved by F. A. in 19 mins