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
.
|