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

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

Related Articles


Your email address will not be published. Required fields are marked *

Cancel Membership

Please note that your subscription and membership will be canceled within 24h once we receive your request.