Microsoft Office Tutorials and References

In Depth Information

**Using INDEX and MATCH for a Left Lookup**

and

achieves the same result in this special case where you are trying to figure

Figure 12.27.

Figure 12.27.
MATCH

MATCH operates slightly more quickly than

operates slightly more quickly than VLOOKUP

VLOOKUP and

achieves the same result in this special case where you are trying to figure

out whether a value is in another list.

out whether a value is in another list.

For any cells where column D contains a number, it means that the entry was

on the original list from last week. If the result of MATCH is #N/A, you know

that this item is new since the previous week.

Using

Using
INDEX

INDEX
and

and
MATCH

MATCH
for a Left Lookup

for a Left Lookup

INDEX is another function that does not immediately seem to have many great

uses. In its basic form, INDEX returns the value from a particular row and

column of a rectangular range. It returns a value from a particular posi-

tion of a vertical or horizontal vector.

Typically, you specify a rectangular range and then indicate the row number

and column number of the value that you want to return. In
Figure 12.28
, the

formula in C3 returns the third row and second column of B5:D9. Certainly,

this is a needlessly complicated way to point to cell C7.