Current location - Training Enrollment Network - Mathematics courses - The names in the two excel tables are the same, but the order is different, and the scores of mathematics and Chinese are recorded separately. How to combine them into a table?
The names in the two excel tables are the same, but the order is different, and the scores of mathematics and Chinese are recorded separately. How to combine them into a table?
For example, column A of sheet 1 is the name and column B is the math score.

Then column A of sheet2 is the name, and column B is the Chinese score.

Then you can enter "Chinese" in C 1 of sheet 1.

Then enter the formula =vlookup(a2, sheet2! A: B, 2, 0)

The formula can be pulled down to adjust the Chinese score.