Hi,

I have a spreadsheet that contains a list of part numbers and their quantity
on hand at different locations. When I use Vlookup for the quantity on hand,
it returns only the first location in the list. It doesn't bring the total
for all locations. I would like to lookup each part number's total quantity
on hand. A total of all the locations for each part number. Can Vlookup do
this or do I have to use another function?


Thank You,

Richard