Microsoft Office Tutorials and References

In Depth Information

**An Exact Match Lookup**

FIGURE 20.11
Type 0 (zero) or False for an Exact Match

FIGURE 20.12
Lookup Results for Salary

If you use TRUE or omit the last argument, an approximate match can be

returned. In this case, you DOwant an EXACTmatch. Use:
False
or type
0.
(The value

“

in Excel functions.) The results are shown in Figure 20.12.

Now repeat this procedure and use an exact match in the VLOOKUP to obtain

the last names in column C. This time the Col index num is in column 3. Compare

your results to the values in Figure 20.13. The figure shows the outcome and the

functions.

0

”

is the same as

“

False

”