- Excel Book Excerpt
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.
For more resources for Microsoft Excel: