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

See my last response a little while ago:

=IF(SUMPRODUCT(--(COUNTIF(Mix1!E7:F16,Sheet4!A3:B3)0))
=2,Mix1!T7,0)


HTH
Jason
Atlanta, GA

-----Original Message-----
I posted this before and when I came back to look for

it, I could't find it.
So I'm sorry if it's up here twice. I thought that the

first fix I got worked
but then realized it

didn't.

What I need is for the
MATCH statement (or any statement) to be TRUE only when

the the values in A3
& B3 match exactly with two cells in a row of the array

Mix1!E7:F16. Is
there a way to do this? Thankyou.
--
Chris
.