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.