I need to find the price for Column H on the Product Cost page, using the quanity ordered in Column C and multiplying by the wholesale price in the price schedule on the Price Schedule for Bulk Orders Page. Using this formula doesn't work mathmatically. It is giving the wrong answer. $=$VLookup$($C$3,$Pricing!B$4$:Pricing!F$8,$True$)*$C$3.$ The answer comes back as $$74,000$ when it shouldre be $1850*35\mathrm{.}50=65,675.$ I also need the formula to work on remaining $26$ cells in the Column.

$1$ range you need on the Price Schedule worksheet and think about whether you will use the VLOOKUP or HLOOKUP function.

Return to the Orders worksheet and write your function such that it can be copied down to calculate the order cost for each item

based on the quantity ordered. Then calculate total order cost in Column M$.$