MS Excel - matching and extracting data
Closed
jryanp
Posts
1
Registration date
Wednesday December 15, 2010
Status
Member
Last seen
December 15, 2010
-
Dec 15, 2010 at 04:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 09:12 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 16, 2010 at 09:12 PM
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.
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.
Related:
- MS Excel - matching and extracting data
- Ms excel mod apk for pc - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Ms excel marksheet - Guide
- Gif in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 16, 2010 at 09:12 PM
Dec 16, 2010 at 09:12 PM
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.
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.
