Vlookup in Excel

  • Thread starter Thread starter Eberhard Mayer
  • Start date Start date
E

Eberhard Mayer

Hello,

could somebody help me with the vlookup function in excel. I want to
search a product and the product quantity with vlookup. There could be
the case, that the product occur two or more times and not just one
time. Then I want the cumulated product quantity and not only the
quantity of the first found product.

Kind regards,
Eberhard
 
Sounds like you need to look at

=SUMIF(range,criteria,sum_range)

rather than VLOOKUP.
 
Back
Top