Lookup more than one
 

Hi I have a problem with getting lookup to return more than one result.


A B
_______________
pcs team
1 123 a1
2 145 b2
3 567 a3
4 345 a4
5 123 a1
6 345 a3

I would like get all pcs. that one team have made, is that possible in
a excel formula. I do not have the possibility to sort the teams.

Hope some one can help!

Ramses

Hi!

Try this:

=SUMIF(B1:B6,"A1",A1:A6)

Or, use cell references:

=SUMIF(B1:B6,B1,A1:A6)

Biff

"Ramses" wrote in message
ups.com...
Hi I have a problem with getting lookup to return more than one result.


A B
_______________
pcs team
1 123 a1
2 145 b2
3 567 a3
4 345 a4
5 123 a1
6 345 a3

I would like get all pcs. that one team have made, is that possible in
a excel formula. I do not have the possibility to sort the teams.

Hope some one can help!

Ramses

Thanks Biff

I can not believe it was that simple. :-)

Ramses

Ockham's razor!

You're welcome. Thanks for the feedback!

Biff

"Ramses" wrote in message
oups.com...
Thanks Biff

I can not believe it was that simple. :-)

Ramses