Vlookup in Excel

[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

 

[Stephen Dunn]

Sounds like you need to look at

=SUMIF(range,criteria,sum_range)

rather than VLOOKUP.