I believe "1" is the value which is being looked up here.
So, this formula searches "1" in the range D2 to D7.
thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"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.