IF(MATCH(A3:B3,Mix1!E7:E16,0),Mix1!T7,0) doesn't work, what will?
 

I need the TRUE/FALSE statement to return TRUE only when the two entries in a
row of this two column array match exactly th two entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this? Thankyou.
--
Chris

Try:

=IF(SUMPRODUCT(--(ISNA(MATCH(A3:B3,Mix1!E7:E16,0))))
0,Mix1!T7,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need the TRUE/FALSE statement to return TRUE only when
the two entries in a
row of this two column array match exactly th two
entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this?
Thankyou.
--
Chris
.

Works great. Thankyou

"Jason Morin" wrote:

Try:

=IF(SUMPRODUCT(--(ISNA(MATCH(A3:B3,Mix1!E7:E16,0))))
0,Mix1!T7,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need the TRUE/FALSE statement to return TRUE only when
the two entries in a
row of this two column array match exactly th two
entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this?
Thankyou.
--
Chris
.

I'm Sorry, no it doesn't work. And I wrote it wrong the first time. It should
read, IF(MATCH(A3:B3,Mix1!E7:F16,0),Mix1!T7,0). I need the statement to be
TRUE only when the values in A3 & B3 are matched exactly in a row of the
array Mix1!E7:F16. Thanks, Chris
"Jason
Morin" wrote:

Try:

=IF(SUMPRODUCT(--(ISNA(MATCH(A3:B3,Mix1!E7:E16,0))))
0,Mix1!T7,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need the TRUE/FALSE statement to return TRUE only when
the two entries in a
row of this two column array match exactly th two
entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this?
Thankyou.
--
Chris
.

Scrap that first formula. I had it backwards anyway. Use
this:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm Sorry, no it doesn't work. And I wrote it wrong the
first time. It should
read, IF(MATCH(A3:B3,Mix1!E7:F16,0),Mix1!T7,0). I
need the statement to be
TRUE only when the values in A3 & B3 are matched exactly
in a row of the
array Mix1!E7:F16. Thanks,
Chris

"Jason
Morin" wrote:

Try:

=IF(SUMPRODUCT(--(ISNA(MATCH(A3:B3,Mix1!E7:E16,0))))
0,Mix1!T7,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need the TRUE/FALSE statement to return TRUE only
when
the two entries in a
row of this two column array match exactly th two
entries in A3:B3, but MATCH
doesn't work as an array formula. How can I do this?
Thankyou.
--
Chris
.


.