lookup?

[DieArd]

HI Guys,
Sorry Im not very good at this one.

Please see the below link, pic on photobucket of my screen

http://i48.photobucket.com/albums/f206/dieard/top5.jpg

If you look at the first col, it is "month" I have this running upto june so far.

Basically this is a sheet showing how many sales each individual has made on the month.
I want to be able to put put on the right the top 5 people and their sales.

Would I use vlookup for this? again sorry i have never had to use this feature before.
Any suggestions would be great

 

[DiscoPistol]

You can use these 3 functions

=MATCH(LARGE($D$4:$D$7,1),$D$4:$D$7,0)

in the next column

=INDEX($B$4:$D$7,G4,1)

and finally

=VLOOKUP(H4,$B$4:$D$7,3,0)

DP

Edit *I'm pretty sure there is a way you can combine those but I have a headache thinking about it.......

 

[DieArd]

thanks mate,
I have headache too..... "throws the pain killers over" take 2.

 

[Expiry]

You could try using the =rank() formula. If their sales are in cells c1:c50, for example, insert a column to the left of your data (to enable the proceeding vlookup) and put =rank(c1,$c$1:$c$50), then drag down.

This will rank them from 1 to 50. Then, to the right, you can do a vlookup on rank 1, 2, 3 etc to display your top 5.

 

[Stephan Hoenselaar]

I think the easiest way is to use a Pivot table. You can use a pivot to rank performance and create a Top 5 by double clicking a Pivot Field selecting advanced... and creating a Top5. You can even select Month as a page field. This way you only need one Pivot to cover all of your desires...