Getting text from another cell in the row when using LARGE

[spitinyari]

I have a set of data showing how old something is and in the next cell I have the thing's name, a bit like this:

5 Dog
17 Cat
84 Bird
23 Dinosaur
45 Car
12 Bike
56 House

I am using a LARGE function on the first column to get the top 3 values, like this:

=LARGE(A$1:A$7;1)
=LARGE(A$1:A$7;2)
=LARGE(A$1:A$7;3)

But I also want to get the corresponding bit of text from column B. Is there a way to do this?

I have used these forums for a while and can normally find what I'm after, but this time I just don't know what to search for, so thought I'd post. Any help would be greatly appreciated!

[Robert Tucker]

[spitinyari]

You, my friend, are a bone fide spreadsheet genius. That was exactly what I was after, thank you!

[spitinyari]

I do have some numbers the same. I have done a top 5 and the ones that come in at 3 and 4 are both the same number. When getting the description for rank 4, this seems to be causing it to look at the description cell for entry 3 instead. Is there a way round that?

Currently I am seeing something similar to

100 Dog
90 Cat
78 House
78 House
65 Tree

but I should be seeing

100 Dog
90 Cat
78 House
78 Frog
65 Tree

[Robert Tucker]

If you have:

5 Dog
17 Cat
84 Bird
84 Dinosaur
45 Car
12 Bike
56 House

in A1:B7 then enter:

[spitinyari]

Thanks Robert, that's really helpful