Compare same column on 2 sheets

[jaycee]

Hi,

I am trying to see if the data in sheet 1 is also in sheet 4

I have used the following code

=ISNUMBER(MATCH(A2,Sheet4!A:A,0))

then drag this down to the last row

I then filter out the "TRUE" rows and should end up with the correct answer
But the answer it gives cannot be correct as sheet 1 has 272 rows & sheet 4 has 250 rows but still get the answer of 3 rows incorrect?

Any ideas appreciated

 

[wideboydixon]

Perhaps you have duplicates on Sheet1?

WBD