The vlookup function is a lookup function in Excel that can be used to match data in two or more **s. Here are some basic steps and considerations:
1.Open the first ** you want to match the data, and then select the cell you want to find, for example, in the list to be checked, click the first cell that needs to find data, such as b2, click "Formula" - insert function "" - find and reference "- vlookup", and click OK.
2.Then enter four parameters for the vlookup function. The first parameter is the cell (for example, the name column in the list to be checked, but not the header), which is the cell where the data to be searched is locatedThe second parameter is all the data columns in the existing list (it can also be the main keywords, such as the student's name and grade, which exactly match the list to be checked).The third parameter is the column number of the keyword in ** (for example, in this example, "Grade" is in column 2 of the existing data). Click OK.
3.If you want to make an exact match, then the fourth parameter should be false, and if you want to do a fuzzy match, then the fourth parameter should be true.
4.Move the mouse to the lower right corner of the B2 cell of the list to be checked, and the mouse will turn into a small black "+" double-click to complete the filling of the entire **.
5.In another pending **, repeat the above steps, but this time look for data in the second ** [2].
6.If you want to match under multiple criteria, you can use the multi-criteria matching version of the vlookup function, for example, in column D of sheet2 to exactly match the same cell as a2 of the current worksheet, and return the data corresponding to column 3 (column f of sheet2).
Note that the use of the vlookup function requires some knowledge of excel, and if you are not familiar with the vlookup function, it may take some time to learn and understand. Also, the vlookup function may have an error of "n a" when matching data, which is caused by not finding the matching data, you can use the iferror function to avoid this. The above is the application of the vlookup function, thank you for liking and following the collection!