• Excel Book Excerpt

Excel INDEX Sounds Like an Inane Function

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?

LE10000433.jpg 

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.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: