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

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 =)