How to use VLOOKUP functions in Excel

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!