How to use vlookup function in excel

Open the two tables to be used

Change the Chinese scores in Table 2 , matched to the math transcript in Table 1

First place the mouse cursor on the table where the data is displayed, click the formula toolbar--Insert function-VLOOKUP function, and click OK.

VLOOKUP needs to match through the same fields, math transcript and Chinese In the transcript, the students have the same name. Match based on the name.

Select column A in the search value, as shown in the picture:

Place the cursor At the data value, switch the table to the Chinese transcript table, start from the name column and select the data to be matched, that is, fill in the Chinese score column

where the column number is In the transcript, the number of columns where the Chinese scores are located, that is, column 2, fill in 0 for the matching conditions, and finally click the OK button. Xiaohong’s Chinese scores will be displayed in the math transcript. Drag down to display other people’s scores.

Recommended related article tutorials: excel tutorial

The above is the detailed content of How to use vlookup function in excel. For more information, please follow other related articles on the PHP Chinese website!