Hi,

The (A10=$B$2:$B$7)*(B10=$C$2:$C$7) portion of the MATCH() function will
eveluate to 1 or 0 depending upon whether each condition is true or false.
Therefore, if both conditions evaluate to TRUE, then TRUE * TRUE=1. Any
other combination will lead to 0.
--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"FJ" wrote in message
...
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.