Just what I needed. Thanks
"Peo Sjoblom" wrote:
If you mean that they much match in the same row you would need an array
formula
=IF(ISNUMBER(MATCH(1,(Mix1!$E$7:$E$16=A3)*(Mix1!$F $7:$F$16=B3),0)),Mix1!T7,"no match")
entered with ctrl + shift & enter
if you only need a match in both columns
=IF(AND(COUNTIF(Mix1!$E$7:$E$16,A3)0,COUNTIF(Mix1 !$F$7:$F$16,B3)0),Mix1!T7,"No Match")
Regards,
Peo Sjoblom
"cbaugher" wrote:
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
|