MS Excel - matching and extracting data

Closed
Report
Posts
1
Registration date
Wednesday December 15, 2010
Status
Member
Last seen
December 15, 2010
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello - I have an excel workbook (workbook 1) consisting of 4 sheets, each with approximately 400,000 rows of data. I have another workbook (workbook 2) with one sheet of 3500 rows containing the unique information in one column which I'd like to match against.

Column A in all worksheets contains unique numbers from a ticket management system. Workbook 2's column A contains my control sample which I would like to use to search the 4 sheets in workbook 1 for the corresponding matching numbers. I'd then like to pull out the entire rows of matched data from workbook 1.

I don't know if Vlookup is the easiest option here, but hoping someone here knows the best route.

Any help that can be provided would be most appreciated. Thank you in advance.


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
vlookup function will work. But normally vlook up table will be one sheet. if you want to vlookup at more than one sheet a macro is required. will you be comfortable with a macro

otherwise in four columns you can type vlookup formula for each sheet and three of them will be #N/A and one will give you the data.

choose your comfort level.