Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with vlookup formula
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Formula | Excel Discussion (Misc queries) | |||
VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
What can I add to a vlookup formula to give me a 0 not #n/a | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |