Microsoft Office Tutorials and References
In Depth Information
E2
=VLOOKUP(C2,EmpData,3,FALSE)
F2
=VLOOKUP(C2,EmpData,4,FALSE)
G2
=VLOOKUP(C2,EmpData,5,FALSE)
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
Function
Description
CHOOSE
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.
HLOOKUP
Search JabSto ::




Custom Search