Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
If you mean that they much match in the same row you would need an array
formula =IF(ISNUMBER(MATCH(1,(Mix1!$E$7:$E$16=A3)*(Mix1!$F $7:$F$16=B3),0)),Mix1!T7,"no match") entered with ctrl + shift & enter if you only need a match in both columns =IF(AND(COUNTIF(Mix1!$E$7:$E$16,A3)0,COUNTIF(Mix1 !$F$7:$F$16,B3)0),Mix1!T7,"No Match") Regards, Peo Sjoblom "cbaugher" wrote: 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 |
#4
|
|||
|
|||
Just what I needed. Thanks
"Peo Sjoblom" wrote: If you mean that they much match in the same row you would need an array formula =IF(ISNUMBER(MATCH(1,(Mix1!$E$7:$E$16=A3)*(Mix1!$F $7:$F$16=B3),0)),Mix1!T7,"no match") entered with ctrl + shift & enter if you only need a match in both columns =IF(AND(COUNTIF(Mix1!$E$7:$E$16,A3)0,COUNTIF(Mix1 !$F$7:$F$16,B3)0),Mix1!T7,"No Match") Regards, Peo Sjoblom "cbaugher" wrote: 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 |
#5
|
|||
|
|||
See my last response a little while ago:
=IF(SUMPRODUCT(--(COUNTIF(Mix1!E7:F16,Sheet4!A3:B3)0)) =2,Mix1!T7,0) HTH Jason Atlanta, GA -----Original 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
How do I ensure dates inputted are during the work week? | Excel Worksheet Functions |