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.
MORE RESOURCES
FOR MICROSOFT EXCEL
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.