Part II: Working with Formulas and Functions
310
The following lookup formulas use the VLOOKUP function:D2 =VLOOKUP(C2,EmpData,2,FALSE)
E2 =VLOOKUP(C2,EmpData,3,FALSE)
F2 =VLOOKUP(C2,EmpData,4,FALSE)
G2 =VLOOKUP(C2,EmpData,5,FALSE)FIGURE 14.1Lookup 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 14.1 lists and describes these functions.Most of the examples in this chapter use named ranges for function arguments. When you adapt these
formulas for your own use, you need to substitute the actual range address or a range name defined in
your workbook.About This Chapter’s Examples