Using Vlookup to bring over a subtotal
 

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

Using Vlookup to bring over a subtotal
 

=sumif([Book2.xls]Sheet1!A:A,F12,[Book2.xls]Sheet1!C:C)

where F12 holds the part number to sum . Column C in your data table
contains the quantity and column A, the part numbers.

--
Regards,
Tom Ogilvy


"Richard" wrote:

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