In Excel, the vlookup() function is used to search for elements that meet the conditions in the first column of a specified range, determine the row number of the cell to be detected in the range, and then further return the value of the selected cell; use The syntax is "vlookup(lookup value, lookup area, column where the lookup result is located, matching type)".
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.
excel vlookup function:
The VLOOKUP function is used to search for elements that meet the conditions in the first column of the specified area, determine the row number of the cell to be detected in the area, and then Further returns the value of the selected cell.
The function has a total of four parameters, the expression is =vlookup (search value, search area, column where the search result is located, matching type)
can be understood as: VLOOKUP (what to look for, in Where to search, after finding it, return the corresponding column of data to the right, precise or fuzzy search)
Usage example:
1. First, open the EXCEL table, In the cell where you want to import data, click the fx above.
#2. Then in the inserted function, find the vlookup function, click the lowered OK button to enter the function parameters.
3. In the box to the right of vlookup-value, select the cell or value you want to search for. As shown in the figure, select cell A2 to search.
4. In the box on the right side of table-array, select the range of data tables to be searched, as shown in the figure.
#5. In the box behind col-index-num, select the serial number of the position where the cell value you want to value is located, as shown in the figure.
6. In the box to the right of range-lookup, enter 0 or false to roughly match. Or enter true to match the data exactly. As shown in the picture, then click OK.
#7. Finally, use the fill tool to fill in the formula to export the required values.
Related learning recommendations:excel tutorial
The above is the detailed content of What is the usage of excel vlookup function. For more information, please follow other related articles on the PHP Chinese website!