Lookup more than one

  • Thread starter Thread starter Ramses
  • Start date Start date
R

Ramses

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help needed with lookup and related functions 3
Using two Vlookup in one Cell 1
Vlookup displays wrong result 10
filtering question.... 1
IF & AND statements 5
in over my head 2
Formula returning #N/A Error---why??? 4
VLOOK with Index - How to get results across instead of down? 3

Back
Top