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.

Related articles
  • Methods and ways to raise questions in primary school mathematics teaching
  • 20 1 1 Guangdong college entrance examination science mathematics volume is a multiple-choice question.
  • Fill in the blanks in the first grade mathematics
  • What is the monotonous interval in the math problem of senior one? How to find monotonous intervals?
  • Can I do securities and stock analysis after graduating from the Department of Mathematics?
  • Mathematics Xiaohe composition
  • How to reduce the burden and increase the efficiency of mathematics in the second volume of senior two
  • Dalian teacher recruitment examination time
  • What are the core logics of discrete mathematics?
  • Three model essays on mathematics lecture notes for the second grade of primary school

    • copyright 2024 Training Enrollment Network All rights reserved