The syntax for `INDEX()`

is `INDEX(array, row_num,[column_num])`

. You're specifying only the `row_num`

with the `MATCH()`

in your formula.

@RET's formula will give you the cell you're looking for because it specifies both the `row_num`

and `column_num`

.

Excel has a helpful feature for troubleshooting these kinds of issues. If you select the cell with your formula, and then click inside the parameter list of one of the functions in your formula, you'll see a dropdown showing what the parameters should be:

Then, clicking one of the parameters in the dropdown highlights what Excel thinks that parameter is in your formula. Just that much can help you find missing commas and parentheses, but the most helpful feature is when you hit the F9 key - that makes Excel evaluate the highlighted portion of your formula:

The above screenshot shows that `(B2:D2=B2)*(B2:D2=D2)`

evaluates to the array `{0,0,0}`

, which is why `MATCH()`

can't find a 1 in there.

If you highlight the two parts of the product separately, you'll find that `(B2:D2=B2)`

evaluates to `{True,True,False}`

and `(B2:D2=D2)`

evaluates to `{False,False,True}`

. Arithmetic operations on arrays converts `True`

and `False`

to 1's and 0's, and performs the equivalent of a logical `AND()`

. So that's why the expression evaluates to an array of 0's - There's no `True*True`

that would give a 1.

**Note:** If you use the F9 feature, be sure to type UNDO (`CTRL`-Z) afterward. Otherwise, if you type `Return` or tab out of the formula, Excel will save the altered formula in that cell. I guess they always like to hand out some bad with the good.

I hope this helps you out, and best of luck.