you need to try some form of vlookup eg
=if(ISNA(VLOOKUP(yourCell, NameOfColARange, False)),0,1)
in col C. Set up a range to define the Column A data (or leave it as cell refs, up to you really). You need the false ion trhere, otherwise it comes up with 'close' matches, not exact.
There are two secrets to success in this world:
1. Never tell everything you know