1. Take the requirement on the chart as an example, take the age data in sheet2 into the age box of sheet1 using the vlookup formula.
2. Enter the function in the age box of the corresponding row of the work number 1, and then select the data that can determine the corresponding value, that is, the same column of the two tables (as shown in the figure). Remember to enter the English comma after the selection.
3. Then switch to the second table, select the same column including **** and the need to take out the data column.
4. 3 in the formula on behalf of the selected columns need data in the third column, 0 on behalf of the need to accurately select the data, if the data does not exist will show the sign # N/A.