Quickly retrieving large amounts of data in excel2007

It's a bit of a hassle to find hundreds of irregular data in hundreds of rows of data. For example, the author of the school recently carried out student data collection work, many teachers are distressed, there is no way to put the hands of the 200 student list in the school total student list (3000 people Excel2007 worksheet) quickly find out? At this time, using the Excel2007 paste function vlookup () can make this "complex" retrieval problem simple.

The search principle is to use the "Find and Reference" function in the Excel2007 paste function vlookup () for the first column of the table area to meet the criteria, determine the row ordinal number of the cell in the range, and then return the value of the selected cell.

Operation Steps:

The first step is to place the Student Name column that you want to retrieve in the first column of the child table worksheet;

In the second step, insert an empty column (column C) after the Name column (column B) of the worksheet on the summary table to display the results of the search, such as displaying the student's name when the data is retrieved;

In the third step, enter the formula in cell C2 =vlookup (B2, child table!) A$2:a$201,1,false) "; If you retrieve the value of B2 cell in the Child table worksheet, the name in B2 is displayed in C2 cell, otherwise the information" #N/a "is displayed;

Step Fourth, drag the fill handle of the C2 cell to copy the formula to the other cells in column C.

Step fifth, in ascending order of column C, retrieves all the records from the child table worksheet in the Summary table worksheet.

Summary: This approach is a good way to retrieve large amounts of data in Excel2007, and you can use this method to merge data from multiple worksheets. But it is best to retrieve the data without duplicate values, such as "Student Number", "ID card number", "registration number", etc., otherwise all the duplicate values will be found out, use to be more careful.