View Single Post
  #1   Report Post  
cbaugher
 
Posts: n/a
Default IF(MATCH(A3:B3,Mix1!E7:E16,0),Mix1!T7,0) doesn't work, what will?

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