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
Column A Column B Column C
a b 0
d c 1
c a 1
e f 0