Originally Posted by
Sambo kid
I am not sure if this is what you want or not. This may give you the answer... =IFERROR(IF(LEFT(A5,2)="in",VLOOKUP(A5,Database!B:C,2,FALSE)+(VLOOKUP(A5,Invoice!A:B,2,FALSE)),VLOOKUP(A5,Database!A:C,3,FALSE)-VLOOKUP(A5,Invoice!A:B,2,FALSE)),"")
The assumption is that if you enter in a cell in A5 of the scanning barcode sheet with a value that is in column B of your database sheet it will take the value in column C and subtract the corresponding value found in the invoice sheet from it.
Bookmarks