Basic syntax and usage of VLOOKUP functions

VLOOKUP function is a lookup function given a lookup target, it can be found from the specified lookup area to return the value you want to find, is one of the most heavy functions in Excel, the basic syntax of the VLOOKUP function is:

VLOOKUP (lookup target, lookup range, return value column number, exact or Blur lookup

Here's an example of using a VLOOKUP function to describe the use of these four parameters

Example 1: As shown in the following figure, you need to find the age of the name according to the name in table Ii.

Formula: B13 =vlookup (A13, $B $: $D $8,3,0)

Parameter description:

1. Find the target: the content or cell reference of the search you specified. In this example, table two, column A, is the name of the lookup target. We'll look in column A in table a based on the name of table Ii.

Formula: B13 =vlookup (A13, $B $: $D $8,3,0)

2, look up the scope (VLOOKUP (A13, $B $: $D $8,3,0)): Specify a lookup target, if not say where to find, EXCEL will be very embarrassed. So the next step is to specify which range to look for. This second parameter of VLOOKUP can be looked up from a range of cells, or it can be found from a constant array or an array of memory. In this example, to find out from table one, how do we specify the scope? It's also a very easy place to go wrong. It is important to note that the given second parameter lookup range does not error if the following conditions are met:

A to find the target must be in the first column of the area. In this case, look for the name of table two, then the name of the table of the Name column, then table one's Name column (column) must be found in the first column of the range. As in this example, the given range starts with the second column, that is, $b$2: $D $, not $a$2: $D $. Because the lookup "name" is not in the $a$2: $D the first column of the area.

B This area must contain the column to which you want to return the value, in this case the value to return is age. The Age column (column D of Table I) must be included in this range, namely: $B $: $D $, if written as $b$2: $C $ is wrong.

3, the number of columns to return the value (B13 =vlookup (A13, $B $: $D $8,3,0)). This is the 3rd parameter of VLOOKUP. It is an integer value. How did it come about? It is the number of columns in the range given by the "return value" in the second argument. In this case we're going to return "age", which is the second parameter lookup range $b$2: $D the 3rd column of the $ $. It is important to note here that the number of columns is not the number of columns in the worksheet (not the 4th column), but rather the first column of the range area to look up. If this example finds the gender of the name, the value of the 3rd argument should be set to how much. The answer is 2. Because sex is in the 2nd column of the $b$2: $D.

4, exact or Fuzzy lookup (VLOOKUP (A13, $B $: $D $8,3,0)), the last parameter is the key to determining the precise and fuzzy lookup of the function. Precision is exactly the same, and the meaning of ambiguity is contained. The 4th parameter, if the specified value is 0 or FALSE, indicates an exact lookup, and a value of 1 or True indicates ambiguity. Here to remind you to remember that in the use of vlookup do not leave this parameter omitted, if this parameter is missing the default value for Fuzzy Lookup, you can not find the exact results.

Tip: Automatically zoom the screenshot. Not only the cutting edge can be automated, if there is a unified picture size requirements, such as a page of a certain part of the size of the demo, grab the picture on the requirements of a unified processing for the same size. At this time, only in advance in the SnagIt capture software set "effect → image scaling → custom scaling", the size set to a fixed value, and then to carry out the catch map operation.