Results 1 to 7 of 7

Thread: Looking for match from different sheets with returned value if found

  1. #1

    Looking for match from different sheets with returned value if found



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the file.
    Attached Files Attached Files

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

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    in cell B2 put the below formula

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

  5. #5
    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?
    Attached Files Attached Files

  6. #6
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    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.
    Attached Files Attached Files

  7. #7
    is it normal for processing takes time? sometimes if freezes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •