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
Search JabSto ::




Custom Search