vlookup function. vlookup is to find by column, and ultimately return the value corresponding to the required query column order of the column (hlookup is the row, the same usage).
In the work number 1 corresponding to the age of the line enter the function, and then select the corresponding value of the data can be determined, that is, the same columns of the two tables (as shown in the figure). Remember to enter the English comma after selecting.
Then switch to the second table, select the column that includes the *** same column and the data that needs to be taken out.
3 in the formula on behalf of the selected columns you need the data in the third column, 0 on behalf of the need to pick the exact data, if the data does not exist will show the #N/A sign.