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.
INDEXcan process arrays.