Help with MATCH function

F

FJ

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),(ISNUMBER(MATCH(C11,$B$11:$B$82,0))=TRUE)),"Yes","No")

Can anyone help? Thanks in advance for any information.
 
M

Max

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
 
J

Jacob Skaria

Another way ..use COUNTIF...

in cell D2
=IF(COUNTIF(A:B,C2)=0,"No","Yes")


If this post helps click Yes
 
F

FJ

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! :)
 
J

Jacob Skaria

"" 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
 
F

FJ

Hi, Jacob, thanks for the information. :)



Jacob Skaria said:
"" 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top