Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE