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?

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

ctrl+shift+enter, not just enter


"kamelone" wrote:

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?

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kamelone" wrote:

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?