Results 1 to 3 of 3

Thread: Compare

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I need a formula that does the following: If the contents of cell A1 on worksheet A of file 1 that is open matches any of the cell contents the range A1:A10 on worksheet A of file 2 that is not open, insert a "Yes" in B1 on worksheet A of file 1. If the contents of cell A1 on worksheet A of file 1 that is open does ot match any of the cell contents the range A1:A10 on worksheet A of file 2 that is not open, insert a "No".

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try
    Code:
    =IF(ISERROR(MATCH(A1,'C:\Excel\[File 2.xls]A'!A1:A10,0)),"No","Yes")
    with the correct path, filename and sheet name substituted.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='774727' date='11-May-2009 15:05']Try
    Code:
    =IF(ISERROR(MATCH(A1,'C:\Excel\[File 2.xls]A'!A1:A10,0)),"No","Yes")
    with the correct path, filename and sheet name substituted.[/quote]

    Thanks Hans.

Posting Permissions

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