<div>
Instead of a lookup, why not make it dynamic: Turn on Filter and filter the column by top 5. Let me know if you need more details on how to do this
</div>


Instead of a lookup, why not make it dynamic: Turn on Filter and filter the column by top 5. Let me know if you need more details on how to do this

<div>
I do no think that will work for what I am doing. I have another spreadsheet with each Store having it own tab with a bunch of data being pulled from multiple excel files to populate it. I am trying to figure out a way to be able to report the top 5 sales people by location from a large list that will update weekly.
</div>


I do no think that will work for what I am doing. I have another spreadsheet with each Store having it own tab with a bunch of data being pulled from multiple excel files to populate it. I am trying to figure out a way to be able to report the top 5 sales people by location from a large list that will update weekly.

IT Systems Manager

Cole100

<div>
Works perfectly. Array Formulas are new to me. Now I am reading everything I can about them. Thank you for the knowledge.
</div>


Works perfectly. Array Formulas are new to me. Now I am reading everything I can about them. Thank you for the knowledge.

<div>
You're welcome Cole! Glad it worked as desired.
</div>


You're welcome Cole! Glad it worked as desired.

<div>
<div class="content wysiwyg-content">
Using Excel Office 365. Trying to create a lookup function that would pull only the top 5 records per location out of a large list even though more than 5 records exist. If only 3 records exist it would leave 2 fields empty.<br />
<br />
Screenshot. Type store # in yellow box and it would auto fill the green boxes. <a href="https://filedb.experts-exchange.com/incoming/2019/01_w02/1409353/5Lookup.JPG" target="_blank" title="screenshot (76 KB)"><img alt="screenshot" class="file-block lazyload" style="max-width: 702px;" data-src="https://filedb.experts-exchange.com/incoming/2019/01_w02/1409353/5Lookup.JPG" /></a><br />
I've also attached the excel file.
</div>
</div>


5Lookup.JPG

Using Excel Office 365. Trying to create a lookup function that would pull only the top 5 records per location out of a large list even though more than 5 records exist. If only 3 records exist it would leave 2 fields empty.

Screenshot. Type store # in yellow box and it would auto fill the green boxes. 

I've also attached the excel file.

Lookup function to only pull 5 top records out of a large list

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.