Back to the INDEX Function
This third and final argument is the Column_num argument which tells Excel the column number in the range D6 to F11 where it will find the information we want returned by the function. In this case, a supplier for titanium widgets.
For help with this example click on the image above.
- Click on the Column_num line in the dialog box.
- Enter the number three " 3 " (no quotes) on this line since we are looking for data in the third column of the range D6 to F11.
- Do not Click OK or close the INDEX function dialog box. It must remain open for the next step in the tutorial - creating the array formula.