Get all rows based on input values from a list
I have one spreadsheet with approx 50000 rows. It contains 24 columns with column A (Name) as a key column. However with multiple occurrences. I have a list of names, and for each name I want to list all the occurrences (with all 24 columns) in my spreadsheet based on the value in column A. I can to this one by one name from my input list by manually using the 'Search' and 'Textfilter Equal to' in my spreadsheet.
However I want to perform my search using the whole list in one go, and not one by one name. Is it possible?
Will I have to use the vlookup function? Or another way to handle this?
|