How to check whither a text is existed

[MFS]

Please help me.
Example: I have data in Column A as following:
A1: G111
A2: G112
A3: G113
I have updated date in Column C as following:
C1: G112
C2: G113
C3: G114
Now, I want a function or formula to be entered in Column B, so it checks A1
value if it is existed in any of Column C cells, I want it to check all cells
in Column C.
After that I will be able to check the others A2, A3 …
Please help me.

 

[T. Valko]

Try this:

Entered in B1 and copied down as needed:

=IF(COUNTIF(C$1:C$100,A1),"Y","N")

Y = yes, it's there
N = no, it's not there

Adjust for the correct end of range C$100.

 

[MFS]

Thank you T. Valko (I want to kiss you) you are my hero.

I just adjusted it like this:
=IF(COUNTIF(C$1:C$100;A1);"y";"n")
I changed "," to ";" as you can see

Now it is working very well, thanks T. Valko

 

[T. Valko]

You're welcome. Thanks for the feedback!