This may work for you too:
=INDEX($B$1:$B$8,MATCH(1,($A$1:$A$8=A2)*($B$1:$B$8 =B2),0))
Commit with Ctrl + Shift + Enter (not just Enter).
Fill down as needed.

--
RyGuy


"Bob Phillips" wrote:

=SUMIF(A1:A8,A2,B1:B8)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pvuv" wrote in message
...
hello.
i am a project planner and doing a quantity analysis whose spreadsheet is
huge & simalar to this eg :

code quantity
a 12
s 3
d 45 total A = 12
a 6
g 67
a 7
d 88

when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE)
it gives me the value 12 instead of the summation (12+6+7= 25)

is dere any way i can get multiple values using vlokup.