- 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
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?
Figure 432 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: