S
sonar
Hi, I am busy setting up something for someone, basically this perso
receives reports of what was supplied, this is imported into Excel.
We have a Stock request sheet then that reads these reports and fill
in the quantities received for each item. It recognizes each item b
its barcode.
The problem is, if the item appears more than once, it only gives m
the quantity for the first one it finds and ignores it thereafter.
Can I formulate this code to find for instance all the 2020465
barcodes and combine the quantities?
=VLOOKUP($A10,Mo!$A$1:$H$9999,3,FALSE)
Kind regards
Sona
receives reports of what was supplied, this is imported into Excel.
We have a Stock request sheet then that reads these reports and fill
in the quantities received for each item. It recognizes each item b
its barcode.
The problem is, if the item appears more than once, it only gives m
the quantity for the first one it finds and ignores it thereafter.
Can I formulate this code to find for instance all the 2020465
barcodes and combine the quantities?
=VLOOKUP($A10,Mo!$A$1:$H$9999,3,FALSE)
Kind regards
Sona