Excel: INDEX Sounds Like an Inane Function

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.


Problem: I was reading Excel Help for fun the other day and I read about a function called INDEX. Who in their right mind would ever use =INDEX(B4:G22,2,4) to point to cell F6?

  1. The INDEX function seems useless.

    Strategy: You will never use INDEX without using MATCH as either the second or third argument. Come back to INDEX after you see what MATCH does.


For more resources for Microsoft Excel