VLOOKUP
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
|