MS Excel - matching and extracting data [Closed]

Report
Posts
1
Registration date
Wednesday December 15, 2010
Status
Member
Last seen
December 15, 2010
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!