I need to find a faster way to extract data form a list. I have a file i wanted to attach so you may have an idea of what I am actually referring to, but couldn't.
On the first tab I have a list with all the individuals and in each column a data referring to them. On this list individuals may appear more than once as they the data is for the whole year for every paydate ( 2x a month). From this list ( 8000 rows), I need only the data for certain individuals ( sheet 2 of the file).
I need a solution to extract all the rows from the list for these specific individuals. In the past I have had to manually use the filter list and filter them. I have tried vlookup but that brings up only the first entry it finds.