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?

What you're describing is the kind of thing one might use a Word mailmerge for; in particular, a directory merge with grouping. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. Mailmerges allow you to filter by all the names of interest

An alternative is to copy, then sort the data in Excel, then delete the unwanted rows.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]