VLOOKUP is doing its job: finding the first instance in a list, and
returning a value. Do you need to sum all the values associated with
your lookup item? If yes then try SUMIF.