In daily work, VLOOKUP is a very useful Excel function that finds a specified number in the first column of a table or array of values, and returns the numeric value at the specified column in the current row of the table. Here's an example of Excel2007, step-by-step diagram of how to use the VLOOKUP function.
Example of a problem set
For example, there are two tables, respectively: a table
and b Table
The example requires that the value of column C in table A in table B be automatically filled with the same value (identical, case-insensitive) of column A of List A and B in table A in B26 B31.
Detailed steps
1, first select the B table B26, and then select the formula:
Pop-up function edit box:
2, the 4 customizations are fully filled on OK, the first down is:
Use the mouse to select the B-Table A26, which is the search term that is followed when returning B26, and the syntax is automatically entered in the edit box.
3. The second customization is:
The direct mouse selects the entire A:C column in table A, which is the search scope. If you want to delineate a specific range, we recommend that you use the $ limit to prevent errors when you copy the formula later.
4. The third one is:
In this example, the value to be returned is in the 3rd column of the search range outlined above, and you can type the number 3.
5, the last one:
Usually requires an exact match, so you should fill in false or you can type the number 0 directly, meaning the same.
6, after the confirmation, you can see the return value in table B B26:
7, finally, the formula can be copied down. Check it out, is it perfect?
Attention matters
In the 2nd step, because it is ultimately a list to return, you can also directly select A26:a31 or even the entire column A (if there are no other distractors).
If it is a excel2003 environment, only step 1 is different, that is, choose "Insert"-"formula", in the "Find and Reference" category find VLOOKUP, the following is the same!