How to Use Excel to Automatically Create Reports – Part 2: Extract Multiple Records

Learn How to Use Excel to Automatically Create Reports with John Lythe

Part 2: Extract Multiple Records

This is the part two of this exercise. What we are going to do this time is to add a second set of data to our table and then look to extract both sets to our report. Unfortunately vlookup is no longer going to work for us because it will only find and extract the first record in a table that meets our criteria. So given that our criteria is simply the name of an athlete vlookup isn’t the solution for us. What we can do in index and match combination like we did in the last video to extract both of first and the second and a few more records we could extract them as well.

To find out more, please watch the video below.

Click Here to Download the Example Workbook

I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »

Home Forums How to Use Excel to Automatically Create Reports – Part 2


This topic contains 0 replies, has 1 voice, and was last updated by mm John Lythe 1 year ago.

You must be logged in to reply to this topic.