Hi Chris
not sure if this is the best answer but
=IF(ISNA(INDEX(E7:E16,MATCH(A3&B3,E7:E16&F7:F16,0) )),"Not found","found")
entered with control & shift & enter not just enter
this will return "found" if the values in A3 & B3 match with values in E & F
on the same row respectively.
Cheers
JulieD
"cbaugher" wrote in 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
|