• Comparing 2 Files

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Comparing 2 Files

    Author
    Topic
    Nancy O.
    Guest
    June 4, 2001 at 7:16 pm #1769639

    I’m trying to determine if I have duplicate information on 2 separate files. An ex-colegue once showed me how to use VLook Up to identify cell content that is on both files (but I can’t remember how to do this). Here’s the situation…I’ve employee names that I want to know are the same on file 1 and file 2.

    Thanks,
    Nancy

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSgibbindr
      AskWoody Lounger
      June 5, 2001 at 2:01 am #1784066

      The last parameter of Vlookup is Range_Lookup. If it is set to false then you need an exact match to return a result. Something like
      =vlookup(testname,matchlist,1,false)
      If you name is there then you get at match else you get an error.

      Reply | Quote
    • WSHans Pottel
      AskWoody Lounger
      June 5, 2001 at 9:12 pm #1784098

      Another trick might be to use something equivalent to

      =IF(COUNTIF(Sheet1!$A$1:$A$8;A1)>0;A1;””)

      Here I assumed that one list is in the range A1:A8 on Sheet1 and the other list is e.g. in the range A1:A20 on sheet2. Now, fill in the formula above on the cell B1 on sheet2. Fill down the cells by copying this formula to the cells B2 up to B20. If the cell content of each cell on sheet2 appears in the list on sheet1, this formula will display the cell contents of the corresponding cell in column A and will leave the cell empty if not present in the first list.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Comparing 2 Files

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.