Simon, everything is working just fine now.
Thank you for your help, it is greatly appreciated.

"SiC" wrote:

Paula,

One important note is that the code column must be the left most column in
the table array range, meaning the code column in the invoice sheet must be
moved to the left.
So move the column in invoice sheet so that
Column A - has the code
Column B - has the quantity sold
Then try
=H6-(VLOOKUP(B6,Invoice!$A$16:$B$32,2,FALSE))
This is basically the formula you used originally, except the column index
has changed from 1 to 2, and last argument changed from TRUE to FALSE.

-Simon

"Paula_p" wrote:

Hi,
I have two worksheets, an invoice, and an inventory. What i need is to be
able to deduct quantity sold (from the invoice) from the quantity in stock
(in the inventory). I tried using a vlookup formula to get the product code
from the invoice and subtract the quantity sold from an amount bought and
recorded in the invetory list. The formula is as follows:
=H6-(VLOOKUP(B6,Invoice!$A$16:$B$32,1,TRUE)). However, this only reduces the
amount by 3, whether or not the amount sold is 3. Does anyone know what i'm
doing wrong? Please, any help is appreciated.

Column H - has the anount of goods bought and is available for sale.
Column B - has the unique probuct code.

In the invoice sheet,
Column A - has the quantity sold
Column B - has the code

Thank You.