|
Help with MATCH function
Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I
am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
Try it like this:
=IF(C11="","",IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82 ,0)),ISNUMBER(MATCH(C11,$B$11:$B$82,0))),"Yes","No ")) Works fine? Celebrate your success, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
Another way ..use COUNTIF...
in cell D2 =IF(COUNTIF(A:B,C2)=0,"No","Yes") If this post helps click Yes --------------- Jacob Skaria "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
Hi, Max, thank you very much for your help. :) Your formula worked great. :)
Just one quick question: what does the part C11="","" mean? I don't think I've ever seen that before, but then my experience with formulas like these is very limited. Thanks again for your help! :) "Max" wrote: Try it like this: =IF(C11="","",IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82 ,0)),ISNUMBER(MATCH(C11,$B$11:$B$82,0))),"Yes","No ")) Works fine? Celebrate your success, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
Hi, Jacob, thanks for your help. :) Your formula worked great, too. :)
"Jacob Skaria" wrote: Another way ..use COUNTIF... in cell D2 =IF(COUNTIF(A:B,C2)=0,"No","Yes") If this post helps click Yes --------------- Jacob Skaria "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
"" denotes blank .
=IF(C11="","",formula) means If C11 is blank then return blank or otherwise return the formula result If this post helps click Yes --------------- Jacob Skaria "FJ" wrote: Hi, Max, thank you very much for your help. :) Your formula worked great. :) Just one quick question: what does the part C11="","" mean? I don't think I've ever seen that before, but then my experience with formulas like these is very limited. Thanks again for your help! :) "Max" wrote: Try it like this: =IF(C11="","",IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82 ,0)),ISNUMBER(MATCH(C11,$B$11:$B$82,0))),"Yes","No ")) Works fine? Celebrate your success, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
Help with MATCH function
Hi, Jacob, thanks for the information. :)
"Jacob Skaria" wrote: "" denotes blank . =IF(C11="","",formula) means If C11 is blank then return blank or otherwise return the formula result If this post helps click Yes --------------- Jacob Skaria "FJ" wrote: Hi, Max, thank you very much for your help. :) Your formula worked great. :) Just one quick question: what does the part C11="","" mean? I don't think I've ever seen that before, but then my experience with formulas like these is very limited. Thanks again for your help! :) "Max" wrote: Try it like this: =IF(C11="","",IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82 ,0)),ISNUMBER(MATCH(C11,$B$11:$B$82,0))),"Yes","No ")) Works fine? Celebrate your success, click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "FJ" wrote: Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see if there is a match in column A or column B and, if there is a match in either of those columns, then I want to put the word Yes in column D. If not, then I want the word No to appear. This is the formula I have so far but it is yielding incorrect results: =IF(OR(ISNUMBER(MATCH(C11,$A$11:$A$82,0)=TRUE),(IS NUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No" ) Can anyone help? Thanks in advance for any information. |
| All times are GMT +1. The time now is 09:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com