7 reasons why you should get cozy with INDEX()

7 reasons why you should get cozy with INDEX()
22 September 2013

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.