Microsoft Office Tutorials and References
In Depth Information
Figure 8-1: Lookup formulas in row 2 look up the information for the last name in cell C2.
This particular example uses four formulas to return information from the EmpData range. In many cases, you'll
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 8-1 lists and
describes each of these functions.
Table 8-1: Functions Used in Lookup Formulas
Returns a specific value from a list of values supplied as arguments.
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.
Search JabSto ::

Custom Search