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

C

cbaugher

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

cbaugher

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 said:
Try:

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

HTH
Jason
Atlanta, GA
Click to expand...
 
J

Jason Morin

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
Click to expand...
 
Top