Microsoft Office Tutorials and References
In Depth Information
Adding a Lookup Table
Select the range I9:I21
and then click the
Percent Style but-
ton on the Ribbon.
Click the Increase
Decimal button on
the Ribbon twice.
=H9 / G9
Click the Center
button on the
Ribbon to center
the range I9:I21
(Figure 5–20).
Select the range
A7:J7, right-click the
selected range, click
Format Cells on the
shortcut menu, click
the Alignment tab,
click the Horizontal
box arrow, click
Center Across
and then click the
OK button.
calculated column
automatically when
formula entered in
fi rst row
two decimal
places in
column I
Select the range
J9:J21 and then click
the Center button on
the Home tab on the
Ribbon. Select cell J9
to deselect the range
Figure 5–20
Adding a Lookup Table
Lookup Functions
Lookup functions are
powerful, useful, and
interesting in the way
they work. For additional
information on lookup
functions, enter vlookup
in the Search box in the
Excel Help window.
The entries in the % of Quota column give the user an immediate evaluation of where
each sales rep’s YTD Sales stand in relation to their annual quota. Many people, however,
dislike numbers as an evaluation tool. Most prefer simple letter grades, which, when used
properly, can group the sales reps in the same way an instructor groups students by letter
grades. Excel contains functions that allow you to assign letter grades based on a table.
Excel has several lookup functions that are useful for looking up values in tables,
such as tax tables, discount tables, parts tables, and grade tables. The two most widely
used lookup functions are the HLOOKUP and VLOOKUP functions. Both functions
look up a value in a table and return a corresponding value from the table to the cell
assigned the function. The HLOOKUP function is used when the table direction is hori-
zontal, or across the worksheet. The VLOOKUP function is used when a table direction
is vertical, or down the worksheet. The VLOOKUP function is by far the most often used
because most tables are vertical, as is the table in this chapter.
Search JabSto ::

Custom Search