View original (French)

[Excel] Check if cells in column A exist in column C

Solved
chatBoO Posted messages 16 Status Member -  
chatBoO Posted messages 16 Status Member -
Hello everyone,

I'm reaching out to ask for your help in resolving an Excel function issue with one of my files.

To keep it short, I would like to know if the cells in column A are present in column C. If they are present, column B should return "Yes"; otherwise, it should return "No".

I used the following [IF()] and [MATCH()] functions in column B:

=IF(MATCH(A2,$C$2:$C$3969,0),"Yes","No")

BUT my problem is that when the value of the cell is present in column C, the function correctly returns "Yes", but when it is not there, it returns N/A instead of "No"... Why?

Because my value if true is "Yes" and my value if false is "No"...

Perhaps the MATCH() function is not appropriate, or maybe I need to nest some "OR" or I don't know... I await your responses and thank you in advance for your involvement :-)

For your tests, here is the link to my Excel file below:

http://www.cjoint.com/c/GFgqjLLe16M

Thanks again =)

4 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    just check with, in B2:
    =IF(COUNTIF(C:C,A2),"yes","no")

    you can also directly detect in column A by using conditional formatting and this formula in the conditional formatting window:
    =COUNTIF(C:C,A1)

    like here:
    https://mon-partage.fr/f/FrBz6cBe/

    Best regards

    The quality of the answer mainly depends on the clarity of the question, thank you!
    4
    1. chatBoO Posted messages 16 Status Member 1
       
      Thank you, the COUNTIF function works very well =^.^= =)
      0