Thanks for the response. I work with Pivot Tables pretty frequently, but I
don't think that will solve my problem in this case. I should have been more
clear in my orginal post - that I'm trying to find the top 3 vendors for each
client based on the number of units. I've sorted the spreadsheet so that the
top 3 vendors are listed on the top 3 rows for each client, but it's a very
large amount of data and it would take a long time to cut and past the first
3 rows of each client. A more accurate example of the data would be-

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

Thanks again.

"CLR" wrote:

I don't use them much, but you may be able to build a pivot table to display
the results you're seeking. If you're not up on them, Debra has lots on
Pivot Tables at www.contextures.com

Vaya con Dios,
Chuck, CABGx3

"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