Suppose that the columns of material 1 are: name, information 1, information 2,. .

The columns of the answer 1 are: name, information 1, information 2,. .

Select the material 1 table and enter sucai in the Name box.

Fill in the formula of C2 B2, ... Answer 1: =VLOOKUP($A2, sucai, 2), =VLOOKUP($A2, sucai, 3), ......

Select B2, C2, ... point to the drag handle and drag the copy formula down. The number of rows to copy depends on the number of rows of the answer 1.

Then in A2, A3, ..., the contents of other cells in the answer sheet will be automatically transferred from the bill of materials.

The meaning of VLOOKUP($A2, sucai, 2) is to search in the first column of sucai cell area according to the value of $A2 cell, and if it is found, take the data value of the second column of this row.