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