Microsoft Office Tutorials and References
In Depth Information
An Exact Match Lookup
FIGURE 20.6 The Results of VLOOKUP
FIGURE 20.7 The Grades Are Obtained from the Third Column
FIGURE 20.8 Getting the Results for the Rest of the Database
AN EXACT MATCH LOOKUP
When you require an exact match of the values you look up, you need to indicate in
the last argument of the lookup table (called
) that you do not want
an approximate value. This time, as you want an exact match, you need to enter the
word
Range lookup
False
to indicate it in the VLOOKUP menu.
 
Search JabSto ::




Custom Search