As column number is blank, the INDEX function returns the entire 2 nd row. Here the array part of the INDEX function is A3:C8. Then I have pressed CTRL + SHIFT + ENTER to enter the array formula. To enter this formula, I have selected the cell range B16:D16 and then entered the formula in the cell B16. You might find Example 1 (and also Example 2) a little bit harder to understand. INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range. This part is optional for them who already are using heavily the following Excel functions: Excel-find-text-in-range-and-return-cell-reference
