Excel automatically generates the contents of the next column according to the contents entered earlier.

This requires a lookup function. As upstairs said, first set up a comparison table and enter the serial number and the corresponding name and address. Then enter the function in the query worksheet: suppose your table is from A 1, as shown below:

Serial number, name and address

1 Beijing Area A

Enter 1 in the query table A 1 to query the manufacturer represented by this number. Enter A2.

=IF(ISNA (look up (A 1, cross-reference table! $ A； $A, comparison table! B: b)), "Wrong number", look up (A 1, cross-reference table! $ A； $A, comparison table! B: B))

Get in the car and confirm. Then drag the copy formula to the right.