Looking for match from different sheets with returned value if found

[kewl25]

I want to compare Column A of two worksheets and return a result in column B of worksheet 1 with either True if exist or False if no match found.

 

[sambit]

Hi,
plz see the file.

 

[kewl25]

Hi it worked..how to make it entire column as reference (without specifying up to specific range)?

 

[sambit]

Hi,
in cell B2 put the below formula

=ISNUMBER(MATCH(A2,'MRN IS INCORRECT'!A:A,0))

 

[kewl25]

I have a followup question

Now I have to 2 files and I want to compare filename "Published" under worksheet "Correct MRN Sorted By MRN" Column B with filename "ALLMRN" sheets 1 to 4.

If the numbers in sheets 1 to 4 exist in "published" column B, it will return a value under Exist column as TRUE, if not exist FALSE

is it possible for multiple worksheets and separate files?

 

[sambit]

Hi,
You have to create a Sheet List. Then Put the below formula in Cell D2 (Published File)

=IFERROR(MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A$2:$A$1000"),B2)>0),0)=1,"False")

Ctrl+Shift+Enter

Note: Both file should be open.

 

[kewl25]

is it normal for processing takes time? sometimes if freezes