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.