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.