Microsoft Office Tutorials and References

In Depth Information

**Using VLOOKUP with FALSE to Find an Exact Value**

55. When using this version of VLOOKUP with ranges, sort the list in as-

cending order. If you are not sure of the proper order, use the Sort

command from the Home tab to sort the table.

66. Because the first argument in the VLOOKUP function is the student
’
s

score, in cell C2, enter =VLOOKUP(B2,

=VLOOKUP(B2,.

77. Because the next argument is the range of the lookup table, be sure to

press the F4 key after entering E2:F6 to change to an absolute refer-

ence of $E$2:$F$6.

88. Ensure that the third argument specifies which column of the lookup

table should be returned. Because the letter grade is in the second

column of E2:F6, use 2 for the third argument.

99. Ensure that the final argument is either TRUE or simply omitted. This

tells Excel that you are using the sorted range variety of lookup.

10.

10. After you enter the formula in cell C2, again select cell C2 and

double-click the fill handle to copy the formula down to all stu-

dents.

Using

Using
VLOOKUP

VLOOKUP
with

with
FALSE

FALSE
to Find an Exact Value

to Find an Exact Value

In some situations, you do not want VLOOKUP to return a value based on a

close match. Instead, you want Excel to find the exact match in the lookup

table.

Figure 12.23
shows a table of sales. The original table had just columns A

through C: Rep, Date, and Sale Amount. Although a data analyst might have

all the rep numbers memorized, the manager who is going to see the report

prefers to have the rep names on the report.