1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Tutorial: Lookup Formula with Multiple Criteria in Excel

By

4 of 10

Entering the INDEX Function Array Argument
Entering Excel's INDEX Function Array Argument

Click on the image to view full size

© Ted French

Entering the INDEX Function Array Argument

The first argument required is the Array argument. This argument specifies the range of cells to be searched for the desired data.

For this tutorial this argument will be our sample database.

Tutorial Steps

For help with this example click on the image above.

  1. In the INDEX function dialog box, click on the Array line.

  2. Drag select cells D6 to F11 in the worksheet to enter the range into the dialog box.

©2014 About.com. All rights reserved.