How to extract corresponding content from another table in excel

Extraction method: First open two tables, select the cell to extract the corresponding content in the table, enter "=vlookup"; then select the location of the search number, select the area where the reference data answer is located; then enter the data The number of columns and "," in the area where the answer is located; finally press the "Enter key".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open an excel table, taking class data as an example:

Open the original data table Table 2, where some data is simulated.

Return to Table 1, select the class cell with the cursor:

Enter =vl and the formula will automatically match, double-click VLOOKUP, if there is no match, enter it manually:

After selecting the formula, select cell A2, and then enter the English comma "," after it:

Go back to Table 2 and select all the data:

Because the data in Table 2 has 4 columns, enter another 4 and an English comma. Enter as many columns as there are.

After pressing Enter in the formula, you can see that cell B2 of Table 1 automatically matches the data of Table 2:

Place the cursor in the lower right corner of cell B2. After the cursor turns into a cross, Zuo Jian double-clicks:

Related learning recommendations: excel tutorial

The above is the detailed content of How to extract corresponding content from another table in excel. For more information, please follow other related articles on the PHP Chinese website!