Excel 2010 Bible

Chapter 14: Creating Formulas That Look Up Values

317

FIGURE 14.5

Using the INDEX and MATCH functions to perform a lookup.

The Excel lookup functions treat empty cells in the result range as zeros. The worksheet in the accom-

panying figure contains a two-column lookup table, and this formula looks up the name in cell B1 and

returns the corresponding amount:

=VLOOKUP(B1,D2:E8,2)

Note that the Amount cell for Charlie is blank, but the formula returns a 0.

continued

When a Blank Is Not a Zero