=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.