Excel two table filter fetch data

To ensure that the data for the two tables are not duplicated, make sure that the fields referenced by your original data table are not duplicated (such as the name in table one is not duplicated, then the name in table two is used as the search criteria).

but your table data can not be duplicated, so it is best to have a field in your table that is uniquely identifiable, such as work number,ID, number, etc. When you're working on your table, replace the fields you reference with the names I used in this document.

Table I:Sheet1=700 person General table

Table II:Sheet2=200 people Roster table

Requirements: The Payroll data in table I is taken to the table II corresponding to the name of the Payroll column

Operation:

1. Select the first pedestrian name in the Sheet2 table: once the first cell corresponding to payroll one, click the function ID in the upper right corner.

2. Select Find and Reference, click OK.

3. Select the VLOOKUP function and click OK.

4. Click on the icon to select the first data in the table Sheet2 Name column (this table is one), the operation chart is as follows:

When selected, click the icon to return.

5. column ordinal: Click the icon.

Open the table Sheet1, press the CTRL key, and select the last name and payroll one or two columns

Click the icon to return:

Note: The second column ordinal content needs to be modified to sheet1!  A:d

6. Sequence Number:

Table Sheet1 Wages in the fourth column, here to fill in 4, fifth column to fill 5, and so on.

7. fill in the matching conditions 0 .

8. Click OK when you are done. Returns the table, when the first data appears

The rest of the stall the first wage cell drop-down is available. No data indicates that the same data in the current table is not found in the Reference data table

---restore content ends---

Excel two table filter fetch data