Question: how to calculate total cost using vlookup?
Answer: VLOOKUP will return a value at the first row that is less than or equal to the lookup value. With weight as the lookup value, VLOOKUP finds and returns the right cost per kg. This cost is then multiplied by the weight to calculate the final cost.