When using the VLOOKUP function, you need to specify the range of data to search. If you are using an Excel spreadsheet, you can select the data range by box selection. The specific steps are as follows:
< br >
1. Open the Excel table and click the cell where you want to enter the VLOOKUP function.
< br >
2. In the function input box, type VLOOKUP and enter the search value.
< br >
3. After entering a comma, enter the start cell of the data range before the data range you want to search.
< br >
4. Click the mouse, then drag to select the cell that contains the data you want to search for.
< br >
5. Enter a comma followed by a column index number or column number (if you are using a column number, you can use letters instead of numbers).
< br >
6. Enter a comma followed by FALSE to ensure that the matching data is found.
< br >
7. Click OK to apply the VLOOKUP function.
< br >
Note that you need to use the HLOOKUP function if the data you are searching for is not in a single column, but is distributed across multiple columns. HLOOKUP is used in much the same way as VLOOKUP, except that HLOOKUP searches by row rather than column.
1. Select the position of the box column to be filled, select the formula, select the insert function
< br >
2. In the window that is displayed, select vlookup and click OK
< br >
3. Under the first box option, move the mouse to select the condition position corresponding to the first representative to be filled.
< br >
4 Select the second option box, skip to the area where the condition is located, and select the area. Then press OK.
< br >
5 Enter 2 in the next option, which is intended to indicate which column of the condition area to get the output, and enter 0 in the space after ah ui to indicate precision.
You can select the vlookup function using the following step box:
< br >
1. Open an Excel table and select the cell where you want to use vlookup function.
< br >
2. Enter the vlookup function in the formula bar, for example, =VLOOKUP(A1,B:C,2,FALSE).
< br >
3. Hold down the Ctrl Shift Space key, which will allow Excel to automatically adjust the column width to fit your data.
< br >
4. Click and drag the mouse to select the data range you want to search.
< br >
5. Release the mouse button and Excel will automatically fill in the search results.
When using the VLOOKUP function, you need to select the region of the query table column and the return value column. You can box the area you want to find in the following way:
< br >
1. Select the cell where you want to place the formula.
< br >
2. Enter " =vlookup(" Then directly hold down the left mouse button, drag the mouse and select the scope you need to query. For example, if you want to query the value of column A, you can select from the A1 to A100 field.
< br >
3. After selecting the data area, add other parameters to complete the formulation of the formula. For example, suppose that the target value you need to query is in column B, you need to put " A1:B100" Inserts into the position of the second parameter in the formula, and continues to supplement other parameters, such as the location of the target value, whether you need to use approximate matching, and so on.
< br >
4. Finally, press Enter and confirm your VLOOKUP formula, which automatically calculates the target value.
< br >
With the above steps, you can box the query table and return value column area of the VLOOKUP function to achieve a quick query.
Cause: The Settings are incorrect. The solution:1. First, select the Excel worksheet and double-click to open it.2. Then, in the MicrosoftOfficeExcel2016 window, the data area provided in another file is displayed.3. Then in the MicrosoftOfficeExcel2016 window, select the cell to display the result of the VLOOKUP function.4. Next, in the microsoftofficeexcel2016 window, click the left \"fx\" button in the formula bar.5. Then in the MicrosoftOfficeExcel2016 window, click the VLOOKUP function.6. Next, in the MicrosoftOfficeExcel2016 window, manually select another data source area in the file.Seven. Then in the MicrosoftOfficeExcel2016 window, click ok.8. Finally, in the MicrosoftOfficeExcel2016 window, the result of the VLOOKUP function is successfully displayed.