How about a simple SUMIF?
In E1, copied down: =SUMIF(A:A,D1,B:B)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Aline" wrote:
The formula on the E1 is =LOOKUP(2,1/(A1:A20=D1),B1:B20), but it only shows
the last cell (on the B column) of the same item on the E column


A B C D E
BIRD 8 BIRD
BIRD CAT
BIRD COW 4
CAT DOG
CAT 9 HORSE 7
CAT
COW
COW
COW 4
DOG 3
DOG
HORSE 7

How can I rewrite the formula that will :

A B C D E
BIRD 8 BIRD 8
BIRD CAT 9
BIRD COW 4
CAT DOG 3
CAT 9 HORSE 7
CAT
COW
COW
COW 4
DOG 3
DOG
HORSE 7
HORSE

Thanks,
Aline
--
Aline