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

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