小站 我們既定的目標和道路既非受苦亦非享樂而是進步，在每一個明天都比今天進步。

INDEX / MATCH -- Example 4

Instead of matching information in column headings, you may need to match information that's stored in the columns, as shown in the table below.

In this INDEX / MATCH example, instead of columns headings of Small, Med, and Large, the size is stored in column C.

You need to find the price from column D, when Jacket is in column B, and Med is in column C.

1. Set up the worksheet as shown at right
2. Enter the following formula in cell C13:      
   =INDEX($D$2:$D$10,MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0))
3. This is an array formula, so hold Ctrl + Shift, and press the Enter key to see the result.

Curly brackets will be automatically added to the formula (don't type them yourself!), so the final result will look like this:

{=INDEX($D$2:$D$10,MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0))}

Next, create a similar INDEX/MATCH formula in cell D13, to get the correct code from column A.