# lookup?

#### DieArd

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

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

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### DiscoPistol

##### Active Member
You can use these 3 functions

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

in the next column

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

and finally

Code:
``=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

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

#### Expiry

##### Well-known Member
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

##### New Member
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...

Replies
1
Views
838
Replies
6
Views
799
Replies
1
Views
303
Replies
2
Views
482
Replies
1
Views
444

1,181,658
Messages
5,931,272
Members
436,786
Latest member
Deniel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back