Does value exist in a column?
You're welcome!
Biff
"Wester" wrote in message
...
Thanks!
-Wesley
"T. Valko" wrote:
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
|