Page 317 - Excel 2007 Bible

20_044039 ch15.qxp 11/21/06 11:07 AM Page 274
Part II
Working with Formulas and Functions
About This Chapter’s Examples
ost of the examples in this chapter use named ranges for function arguments. When you adapt these formulas
Mfor your own use, you need to substitute the actual range address or a range name defined in your workbook.
FIGURE 15.1
Lookup formulas in row 2 look up the information for the employee name in cell C2.
This particular example uses four formulas to return information from the EmpData range. In many cases,
you want only a single value from the table, so use only one formula.

Functions Relevant to Lookups

Several Excel functions are useful when writing formulas to look up information in a table. Table 15.1 lists
and describes these functions.

TABLE 15.1
Functions Used in Lookup Formulas

Function Description
CHOOSE Returns a specific value from a list of values (up to 29) supplied as arguments.
HLOOKUP Horizontal lookup. Searches for a value in the top row of a table and returns a value in the same
column from a row you specify in the table.
IF Returns one value if a condition you specify is TRUE, and returns another value if the condition is
FALSE.
IFERROR* If the first argument returns an error, the second argument is evaluated and returned.
INDEX Returns a value (or the reference to a value) from within a table or range.

274