One way:

=ISNUMBER(MATCH(A2,B$2:B$6,0))

Copy down as needed.

Biff

"Wester" wrote in message
...
Stuck with finding a formula to compare if my value in Column A exist in
my
list of values in Column B, then display result in Column C.

A B C
Fruit Fruit List True/False
Apple Orange True
Kewi Apple False
Orange Banana True
Cherry
Lemon

Any help would be apprecieated.

-Wesley