Array formulas not working in Excel 2003.

[kamelone]

I am trying to use array formulas (to find the value in col C in a row
meeting two criterias in col A and B), but can't seem to make it work.

Problem is I can't even get Excel examples that I copy from the help file to
work with Array formulas. I have tried ctrl+shift+enter and using {}, but no
luck.

Is there any way the array formulas could have been disabled?

 

[Teethless mama]

=INDEX(rngC,MATCH(1,(rngA="criteria 1")*(rngB="criteria 2"),0))

ctrl+shift+enter, not just enter

 

[Shane Devenshire]

Hi,

It would help if you showed us the formula you are using. If there can be
only one value that meets the two conditions then

=SUMPRODUCT(--(A1:A10="condition1"),--(B1:B10="condition2"),C1:C10)

no array entry needed.