• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Excel's Data Management Features > Using MATCH with Other Functions

Using MATCH with Other Functions

You probably won't have much use for the MATCH function all by itself. Think back: How often have you wondered where to find the number 5 in the range C10:C100 by means of a worksheet function? But when you use MATCH as an argument to another function, such as INDEX or OFFSET, you begin to appreciate how valuable it is.

Combining MATCH and INDEX

That aspect of MATCH--being able to find the largest value less than or equal to the value you're looking for--is useful when you have to deal with grouped values as seen in Figure 2.6.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint