Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
Service work order | Charts and Charting in Excel | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
how is possible working on work sheet by two person in the netwo. | Excel Worksheet Functions | |||
Lookup Doesn't Work | Excel Worksheet Functions |