Excel if(match()) function across multiple sheets is returning #N/A

=IF(MATCH(Sheet1!A1,Sheet2!A:A,0)>=1,"",Sheet1!A1)

The logic seems to be working as matches return "" but unique values return #N/A.

Is this a problem from referencing values from across multiple sheets?

Thanks.

-Dave