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.
Search JabSto ::

Custom Search