find if there are same value in a column

[Katrin84]

Hi!
Could you help me?

I'd like to have TRUE (or FALSE) in the second column if a number in the first column is present (or not) in the first column in the second sheet. I tried with a lot of functions and I think i need VBA.

In the example attached 1 and 3 are present in both the column, then it means they are TRUE. 4 is present only in the first one, then is FALSE.

How can i mange to do that?

thank you again

[zbor]

On sheet 1, in B1 try this formula:

=COUNTIF(Sheet2!$A:$A,$A1)>0

and pull down