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: