=INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:A100=A3)* (Sheet2!B1:B100=B3),0))

ctrl+shift+enter, not just enter


"ArthurN" wrote:

I love array formulas (though, Im not expert at them). My favorite is:
{=sum(if(sheet2!a1:a100=a3;if(sheet2!b1:b100=b3;sh eet2!c1:c100)))}
Which will find the appropriate number in sheet2!c1:c100.
To my great disappointment, Ive discovered today that it will display the
expected result if the range c1:c100 contains numeric data only and it wont
display it if theres text data.
So, I got stuck here. Is there a way to find cells containing text data the
same way?
Thanx,
ArthurN