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