how do i get multiple values in vlookup?

[Guest]

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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Richard Buttrey]

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.

Not with Vlookup but try

=SUMIF(A:A,"A",B:B)

Better still, since you may want totals for all the column A values,
take a unique list of all column A valuse in say Column C, then in D1
put

=SUMIF(A:A,C1,B:B)

and copy down.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Richard Buttrey]

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.

Not with Vlookup but try

=SUMIF(A:A,"A",B:B)

Better still, since you may want totals for all the column A values,
take a unique list of all column A valuse in say Column C, then in D1
put

=SUMIF(A:A,C1,B:B)

and copy down.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

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.