Tutorial: Lookup Formula with Multiple Criteria in Excel

By Ted French, About.com Guide

Back to the INDEX Function

Now that the MATCH function is done we will move to the third line of the open dialog box and enter the last argument for 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.

Tutorial Steps

For help with this example click on the image above.

1. Click on the Column_num line in the dialog box.


2. 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.


3. 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.