Excel matching problem

For example, the list of students is in sheet 1.

The name is in column B, the student number is in column C and the class is in column D.. The first line is the title.

B2 formula

=vlookup(c2,sheet 1! A: C, 2, 0)

D2 formula

=vlookup(c2,sheet 1! A: C, 3, 0)

then

Copy B2 merged cells, click B6 and b10 ... cells with ctrl+ mouse, and then paste.

Copy D2 merged cells, ctrl+ click D6, d10 .................................................................................................................................................