Excel: Need to find a matching cell and copy the cell next to it

[BrunoPuntzJones]

Say my grid is something like:

Dog 10
Dog
Dog
Cat 55
Cat
Cat
Mouse
Mouse
Horse 20
Horse
Pikachu


I need the number 10 next to each dog, and a 55 next to each cat, and a 20 next to each horse.

I've tried different IF functions and vlookup doesn't seem to be the right way to go about it.

I need my output to be:

Dog 10
Dog 10
Dog 10
Cat 55
Cat 55
Cat 55
Mouse
Mouse
Horse 20
Horse 20
Pikachu

Any way to do this?

 

[BrunoPuntzJones]

Well I think this may have been a lot more simple than I was making it out to be.

Formula was just:

IF(A2=A1,B1,"EMPTY")

And then just used the find blank cell command and filled in the empty cells in the same column. My output currently is:

Dog 10
Dog 10
Dog 10
Cat 55
Cat 55
Mouse EMPTY
Mouse EMPTY
Horse 20
Horse 20
Pikachu EMPTY

I have to do some spot checking, but it seems to be ok.