Does value exist in a column?
 

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

Does value exist in a column?
 

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

Does value exist in a column?
 

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

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