Duplicate values

[ApolloID]

Hi, i need a formula to check for duplicates.
In sheet1 i have in column H some numbers. In sheet 2 i have also in column H some numbers.
In J column sheet2 i need a formula that will check the duplicates and return true or false if there are duplicates.

Can this be done?
Thanks!

 

[VoG]

Try in Sheet 2 H1 and copied down

=ISNUMBER(MATCH(H1,Sheet1!H:H,0))

 

[VoG]

Sorry that should be

Sheet 2 I1

 

[ApolloID]

It's perfect!!! It's working!
Thanks allot!!