you have to sum the data first to use VLOOKUP
OR try using the SUMIF function.
it will let you do what you want. (*** There's several ...IF functions,
countif, sumif, etc..)



"Dahlman" wrote:

I am running a vlookup for part #'s at my company. The table that I have may
sometimes contain the same part numbers multiple times. I want my vlookup to
look at all of the same part number and give me a total of the column that
I'm looking in. For example

PART # QUANTITY
15300001 100
15906231 52
15308526 78
15300001 69

Now when I do a lookup on a separate worksheet underneath the part number
15300001 I want my quantity to show 169.

Is this possible?...Please help.

Thanks in advance.

Travis Dahlman