Microsoft Office Tutorials and References
In Depth Information
Using VLOOKUP with FALSE to Find an Exact Value
Figure 12.23.
Figure 12.23. In this case,
In this case, VLOOKUP
needs to find the exact rep number from
the table in columns E and F.
VLOOKUP needs to find the exact rep number from
the table in columns E and F.
To fill in the rep names from a lookup table, you follow these steps:
11. In columns F and G, enter a table of rep numbers and rep names. Note
that it is not important that this table be sorted by the rep number
field. It is fine that the table is sorted alphabetically by name.
22. Use FALSE as the fourth parameter in VLOOKUP. You need to do this
because close matches are not acceptable here. If something was sold
by a new rep with number R9, you do not want to give credit to the name
associated with R8 just because it is a close match. Either Excel
finds an exact match and returns the result, or Excel does not give
you a result.
33. For cell D2, you want Excel to use the rep number in A2, so in cell D2,
enter =VLOOKUP(A2,
=VLOOKUP(A2,.
44. The lookup table is in F2:G7, so enter F2:G7
F2:G7 and then press the F4 key
to make the reference absolute. This enables you to copy the formula
in step 7. After pressing F4, type a comma.
Search JabSto ::




Custom Search