hI,

The 1 is the lookup value for the match function. Imagine this set of data
in your table and imagine the formula modified like this which coerces
TRUE/FALSE to 1 and 0

=INDEX($D$2:$D$7,MATCH(1,--(A10=$B$2:$B$7)*--(B10=$C$2:$C$7),0))

1 1 a
2 2 b
3 3 c
4 4 d
99 55 e
5 5 f

Matching 99 and 55

Now we are looking up the number 1 so TRUE (Or 1) is returned every time a
match is found so we get these 2 arrays

0;0;0;0;1;0
0;0;0;0;1;0

As you will see matching 1 is found only on the fifth element of the array
so the fifth element of the INDEX range is returned.

Mike


"FJ" wrote:

Hi, I have what is probably a very simple question about an INDEX MATCH array
formula that I found on the Contextures website. In the following formula:
{=INDEX($D$2:$D$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$ 2:$C$7),0))}
what does the "1" after "MATCH(" indicate?

Thanks in advance for any information.