How to use vlookup function? How to use the vlookup function!

Excel System Daquan believes that users of most office software will not be unfamiliar, although we know that this is a form data processing software, and then used in office applications is very extensive.

Excel is also very powerful, and the operation is relatively simple, but there are some functions that require a more detailed understanding of Excel functions in order to use its powerful function calculation function.

A few days ago to ask Xiao Bian Excel users in how to use the vlookup function, vlookup function actually use small series of previously learned but forgotten a long time almost useless.

Today's system is complete on the online collection of the use of vlookup function, here to share the use of the system collection vlookup function to everyone.

The following examples do answers for your reference:

First, the function of several parameters using vlookup introduced under us, vlookup function is to determine the reference data, which is a total of four parameters , in order:

1, condition 2 of the judgment, area 3 of the trace data, data of the returning column 4, exact match

According to the demand of the problem, the formula should be: =vlookup(a2,sheet1!$a$2:$f$100,6,true)

The use of each parameter in the vlookup function example is as follows:

1, a2 is the condition for the judgment. That is to say, if the data corresponding to column a in the sheet2 table is the same as the data in the sheet1 table, 2, sheet1!$a$2:$f$100 is the area of ​​data tracking, because the data to be referenced is in the f column. So the tracked area is at least in the f column, $ is the absolute reference (refer to the absolute reference here); 3, 6 This is the number of columns returned, the physical of the above figure is the sixth column, so it should be 6, if required English value, then this should be 5; 4, whether it is an absolute reference, if it is true, enter true if it is an approximation Then enter false (approximation is mainly used for finance, calculation, etc. with decimal point); 5, vlookup is the judgment of the vertical direction, if it is the judgment of the horizontal direction, you can use the Hlookup function;

1, a2 is judged Condition, that is to say, if the data corresponding to column a in sheet2 table is the same as the data in sheet1 table; 2, sheet1!$a$2:$f$100 is the area of ​​data tracking, because the data to be referenced is in column f. , so the tracked area is at least in the f column, $ is the absolute reference (refer to the absolute reference here); 3, 6 This is the number of columns returned, the physical of the above figure is the sixth column, so it should be 6, if The value of English is required, then it should be 5; 4, whether it is an absolute reference, if it is, enter true. If it is an approximation, then the condition is met, then enter false (approximation is mainly used for financial, arithmetic, etc. with decimal point); 5, vlookup It is the judgment of the vertical direction. If it is the judgment of the horizontal direction, the Hlookup function can be used.