For example, how to list the single subject scores of all students in Cheng Nan No.2 Middle School in this form from Excel?

The VLOOKUP function can be used to match the same part of two tables. The VLOOKUP function is a vertical search function in Excel. The working principle of VLOOKUP function is to search by column in the target area according to the query value, and finally return the found matching value to the specified cell.

The specific use method is as follows:

1. First, we prepare two different tables at will. Table A contains all the information, and Table B contains some students. Now we need to take out the admission ticket number of the students whose names match Table B and put it in the corresponding column.

2. In the target column, directly enter "=VLOOKUP ()" under English input method. The vlookup function will be automatically prompted during the input process, and you can directly double-click the blue area to select the function.

3. At this point, the complete VLOOKUP function will be displayed in the cell, which has four parameters. For the first parameter, we select the cell in the first column that needs to match the data (such as F3 cell), just select one, and then enter the English comma ",".

4. After the comma, we enter the second parameter. This parameter needs to select a query area in Table A and all the data displayed in the box.

5. After selecting the search area, immediately enter the English comma ",". In the second parameter, because we have selected columns A, B and C, we want to return the value of column C (that is, the third column), so we can directly enter the number 3 in the third parameter, and then continue to enter English. The fourth parameter can directly enter the number 0, and then end the function in English.

6. Copy the function completed by F3 column to other cells, and the responsibility matching is completed.