Array formulas don't like whole columns.

Graham Haughs wrote:

Can someone tell me why the first array formula returns the correct
value, and the second one returns #NUM. The array size increases so I
don't want to limit the size as the first formula does, and thought the
second formula would allow this. Once again I would really value some help.

{=INDEX(A2:A87,MATCH(1,(G93=C2:C87)*(G94=B2:B87),0 ))}

{=INDEX(A:A,MATCH(1,(G93=C:C)*(G94=B:B),0))}

Kind regards,
Graham Haughs
Turriff
Scotland

--

Dave Peterson