Easy way to Learn Vlookup in EXCEL 2007 - Tutorial - Case Study

This is an example, just to understand how vlookup works:

In below figure, Cell C2 displays the value in cell B2, if D2 exactly matches the value in any of the cell in Column A. If matches, it displays the respective value in 2^nd column B (i.e., cell B2) to cell C2.

Exactly matches refer to “FALSE” Boolean type.

In Below figure, it does find the match in D3 and in any cell in column A (here A2), hence, displays respective cell value in B2 in C3.

In below figure, it does not find the match in D4 and in any cell in column A, hence displays 0 in cell C4

Now, change the exact match (FALSE) to approximate match (TRUE) and see the result as below:

Another example for approximate match.

D3 displays the value from Cell F3, once A3 value matches with column F.  A3 cell value 3, is between 1 to 19 in F3.

Below displays value in D4

Below is the example for approximate match using name instead of numbers.

B2 cell displays of A2, if A2 approximately matches C2, as below:

Below displays the value of A3 in B3.

That's it.