Automatic generation of Resumes

Extract important fields from Excel to form a table of information that can be applied to the creation of a resume. Especially if your unit participates in the ISO Quality system certification, you have a deeper experience, each quality certification audit personnel departments need to provide a large number of personnel information, for the staff resume finishing is an essential link. Here we have some function settings to automatically generate resumes, this method has already been on the Internet, the author here simple again, we do not understand the meaning of the function, as long as the formula copy over a little modification, will be used on the line.

3
1. Making Forms
The production method is as follows:
(1) First create a "staff resume" worksheet, draw the table into the chart style.
(2) The next thing to do is in the yellow cell input function formula to facilitate the automatic generation of relevant information, after all functions are set up. In the future, if we want the employee's CV, we can enter his name in the C3 pink cell shown in the picture, and the system will automatically generate the person's resume.
2. Fill in the formula
Because we choose different names and generate biographical information of different people. We need to format some information items before we enter the function formula. If the birth date should be set to date format, otherwise the result of the function operation is a numeric value, the job resume and other parts of the format is best set to automatically wrap, left-aligned, otherwise the text will be formed by the function line. We explain this function as an example of a function set in the "Department" position:
(1) in the "Staff Resume" worksheet, the following formula will be filled in as shown in the C4, the C3 in this formula is
"Staff Resume" worksheet you fill in the "Employee Name" cell Location: =if (ISERROR (VLOOKUP) (C3, personnel information database! B3:ab31,2,false), "", VLOOKUP (C3, personnel information base!) B3:ab31,2,false))

(3) Use the mouse to click the formula bar function Formula Display logo: table_array, such as figure, switch to the Personnel Information database table, with the mouse to delineate all the data, click Enter.
(4) Other yellow areas, you only need to change the number of columns can be, such as sex is 5, you can change the formula 2 to 5 "C3, the Personnel information database!" B3:ab31,5,false "And so on, the entire resume can be set up to complete, as long as we change different names will show the corresponding personnel information resume."
3. Introduction to ISERROR and VLOOKUP
To put it simply, ISERROR, VLOOKUP two functions: formula: Department of =if (ISERROR VLOOKUP (C3, personnel information base!) B3:ab31,2,false), "", VLOOKUP (C3, personnel information base!) B3:ab31,2,false))
(1) ISERROR (value):
Used to test whether the numeric value returned by a function is wrong, and if it is wrong, the function returns True, and vice versa returns false.
(2) VLOOKUP (lookup_value,table_array,col_index_num,range_lookup):

The lookup_value represents the number that needs to be looked up; C3 we need to manually enter the names, but also to find the number.
Table_array represents the range of cells in which you want to find data; B3:ab31 This is the data range of the personnel information base.
Col_index_num is the column ordinal of the matching value to be returned in the table_array area: for example, the serial number of the employee department in the 2nd column, we need to enter 2. Note that the name is shown here as the first column, and the second column of the analogy department, because we do not include the serial number.
Range_lookup is a logical value, and False indicates that an exact match is returned, and if it is not found, the error value #n/a is returned. If the formula "VLOOKUP ()" Returns an error, it displays "Empty" (""), whereas the formula returns results.