Excel: INDEX Sounds Like an Inane Function - II

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


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.