Microsoft Excel Functions & Formulas

Use the INDEX and MATCH functions to search

for a value that matches two criteria

To search for a value that takes one or more criteria into consider-

ation, use the INDEX and MATCH functions together. In this

example, the search criteria can be entered in cells E1 and F1.

Generate a search function using those two search criteria for the

range A2:C11, and return the result in cell E2.

4

To search for a special value considering two criteria:

1. In a worksheet, copy the data in cells A1:C11, as shown in

Figure 11-8.

2. Enter W46 as the first criterion in cell E1, and enter 1235

as the second criterion in cell F1.

3. Select cell E2 and type the following ...