7 reasons why you should get cozy with INDEX()

Of all the hundreds of formulas & thousands of features in Excel, INDEX() would rank somewhere in the top 5 for me. It is a versatile, powerful, simple & smart formula. Although it looks plain, it can make huge changes to the way you analyze data, calculate numbers and present them.

7 reasons why INDEX is an awesome companion:

• Get nth item from a list.
• Get the value at intersection of given row & column.
• Get entire row or column from a table.
• Use it to lookup left.
• Create dynamic ranges.
• Get any 1 range from a list of ranges.
• INDEX can process arrays.