OK, in column A of Sheet1 you have ID's. Where in Sheet2 you want to search for same id's? In some specific column, in some range of columns, or in any column?

Anyway, there is a formula which covers all possible cases:
(assuming ID's on Sheet1 start from A2, insert the formula p.e. into cell B2 and copy it down)
If you search fo ID's in Sheet2 in range of columns A:C
=(COUNTIF(Sheet2!$A:$C;Sheet1!$A2)>0)
If you search fo ID's in Sheet2 in column C
=(COUNTIF(Sheet2!$C:$C;Sheet1!$A2)>0)

Or if you define the tables on both sheets (you have to replace table and column names in formula with your own):
in whole Table2
=(COUNTIF(Table2;Table1[@ID])>0)
in column Column2 of table Table2
=(COUNTIF(Table2[Column2];Table1[@ID])>0)
in columns Column1:Column3 of table Table2
=(COUNTIF(Table2[[Column1]:[Column3]];Table1[@ID])>0)