Application process:

1. Start Excel (please refer to the example for other versions) and open the workbook of employee basic information registration form.

2. Switch to the Sheet2 worksheet and make the frame of the resume table according to the style shown in Figure 2.

3. Select cells (except B2 cells, such as D2 and F2). ) and enter the formula: =IF(ISERROR(VLOOKUP(B2, resume! A3: K 12, *, false)), "",vlookup (B2, resume! A3:K 12，*，FALSE)).

Note: ① The "*" in the above formula indicates the number of columns corresponding to the corresponding data in the "Resume" table: for example, "Date of Birth" is in the "5" column. When entering the formula in J2 cell, change "*" to "5", that is, =IF(ISERROR(VLOOKUP(B2, recovery! A3: k12,5, false)), "",vlookup (B2, resume! A3:K 12，5，FALSE).

② The meaning of the formula is: If the formula "VLOOKUP(B2, resume! A3: k12,5, FALSE) "returns an error (ISERROR), then" empty "("") is displayed, otherwise, the return result of the formula is displayed.

4. Select J2 cell, then hold down the Ctrl key, click C3 cell, select J2 and C3 cells at the same time, and execute the format → cell command to open the cell format dialog box. In the Numbers tab, select the Date option under Category, then select the date type on the right and confirm to return.

5. Select cell B5, open the cell format dialog box again, switch to the alignment tab, set the horizontal alignment and vertical alignment to left alignment and top alignment respectively, select the word wrap option, and confirm to return.

6. Set the font and font size of the table.

In the future, when you need to print an employee's resume form, you only need to enter the employee's name in cell B2. After confirmation, the employee's resume will be automatically filled in the corresponding cell of the form and printed.

;