Using Vlookup to bring over a subtotal

[Richard]

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

[Tom Ogilvy]

=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