not sure how can I describe my question, please help!

[mxc668]

If I had column A and column B, how could I write a formula in Column C to decide whether cell 1 in column B is also in Column A as well? If yes, return value 1 to Column C otherwise return value 0.

Column A Column B Column C
a b 0
d c 1
c a 1
e f 0

 

[Jonmo1]

Welcome to the board...

Countif should do that for you...

In C1
=IF(COUNTIF(A:A,B1)>0,1,0)

Fill down

Hope that helps

 

[dave3009]

In column C put and copy it down

=IF(COUNTIF(B:B, A1), 1, 0)

HTH


Dave


P.S. Welcome to the Board

 

[DonkeyOte]

answered - removed

 

[mxc668]

That works. Thanks a lot.

mxc668

 

[GMorris]

Also, I did this with an array formula in column C:

=IF(ISERROR(MATCH(B1:B4,A1:A4,0)),0,1)

Just another way of doing it!