I was just looking for help for a few formulas.
Formula 1:
This formula takes a products code and searches for it in a VLOOKUP on another sheet (Called Product List), returning the cost price in the cell. However, I also want this to return a 0 if the quantity ordered cell says 0, overriding the cost price from the lookup table. I believe what I need here is a combination of a VLOOKUP and an IF Function.
Formula 2:
This formula takes the order number and searches for it in a VLOOKUP on another sheet (Called September Charges), returning the Cost of Sale in the cell. The only problem is that there is roughly 5 or 6 different Costs of Sale per Order number and I want to ignore all the positive numbers and only count the negative. I believe what I need here is a combination of a VLOOKUP, a SUMIF and a SUM function.
All help is greatly appreciated,
Thanks in advance