Most valuable professional
  • Excel Book Excerpt

Excel INDEX Sounds Like an Inane Function - II

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

INDEX Sounds Like an Inane Function - II

Strategy: The trick is to use INDEX to return a value. Use MATCH as the second and/or third argument to calculate which row or column to return on the fly.

The next four topics show how you can use MATCH with INDEX to solve some common problems.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: