Try:
=IF(SUMPRODUCT(--(ISNA(MATCH(A3:B3,Mix1!E7:E16,0))))
0,Mix1!T7,0)
HTH
Jason
Atlanta, GA
-----Original Message-----
I need the TRUE/FALSE statement to return TRUE only when
the two entries in a
row of this two column array match exactly th two
entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this?
Thankyou.
--
Chris
.
|