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,
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. 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-
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
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.