Hello - hoping someone can help me out.

I need to look at a value in one column and see if it is in a list in
another column depending on the column header.

Eg:

A B C
1Category Name Value
2 x john
3 y bob
4 z jane
5 x mary
6 x bob

I need to return 1 if true and 0 if false dependent on lookups in a
separate sheet:

A B C
1 x y z
2 john bob jane
3 mary

So the answer would be
C2= 1
C3= 1
C4= 1
C5=1
C6=0

Many thanks
Megan