A
Aline
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
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