View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.