VLOOKUP - problem in stock request

  • Thread starter Thread starter sonar
  • Start date Start date
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
 
Instead of vlookup you could use Sumif.
SUMIF(Mo!A$1:A$9999;$A10;Mo!C$1:C$9999)

Per Erik
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM - IF - AND 7
VLOOKUP 7
Sum values from a vlookup 2
I need help with a text and quantity summary report. 2
Formula does not work with 13 digit numbers 4
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Book items into & out of stock 1
Update Stock Inventory 2

Back
Top