2. First, enter the formula =VLOOKUP(A2,' [new Microsoft Excel worksheet. Xlsx]Sheet 1' is in cell C2 of worksheet 2! $A:$B, 2,0), the first parameter is the search value, the second parameter is the search range, the third parameter is the number of search columns, and the fourth parameter is the exact match. After input, press enter to get the matching result;

3. Put the mouse in the C2 cell, drop down and fill in the formula, and you can successfully match the Chinese scores in column 2C of the worksheet.