Simple INDEX MATCH Question
Thanks, everyone, for your help. I think it's clearer now. :)
"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.
|