Thanks for the quick response, but I should have been more clear about what
I'm trying to find. I want to pull the top 3 vendors for each client based
on the number of units. There are about 10 different vendors and based on
the number of units that they've sold to the client - the top 3 vendors is
different for each client. I've sorted the spreadsheet by client (ascending)
and units (descending) so that the first 3 vendors listed for each client
have the most units. Thanks again.

"JP" wrote:

If you want to show the top 3 clients (based on number of units), try
a Pivot Table. In Excel 2003,

1. Highlight your data
2. DataPivotTable And PivotChart Report
3. Follow the prompts to create the Pivot Table
4. Drag "Client" and "Manufacturer" to the Row Field
5. Drag "Units" to the Data Field
6. Double-click the "Client" header, in the dialog box click
"Advanced"
7. Click the "on" radio button in the "Top 10 AutoShow" section
8. Choose "Show | Top | 3" (using field "Sum Of Units")
9. Click "OK" twice

The Pivot Table should now show the top 3 clients based on # of units.


HTH,
JP

On Jan 15, 11:48 am, Nate wrote:
Hello,

I would like to run a report that looks up the first 3 rows of data for each
client in my table. If I do a VLOOKUP it automatically pulls the first row
for each client, but that's it. Is there any way to extend that down to the
top 3? Here's an example of what I'm trying to pull from-

Client Manufacturer Units
Client1 Vendor1 33.0
Client1 Vendor2 25.0
Client1 Vendor3 17.0
Client1 Vendor4 12.0
Client1 Vendor5 5.0
Client1 Vendor6 0.0
Client2 Vendor1 48.0
Client2 Vendor2 22.0
Client2 Vendor3 5.0
Client2 Vendor4 4.0
Client2 Vendor5 4.0
Client2 Vendor6 3.0

Any suggestions would be greatly appreciated. Thanks in advance-

Nate