Results 1 to 3 of 3
  1. #1
    Nancy O.
    Guest

    Comparing 2 Files

    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

  2. #2
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing 2 Files

    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.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing 2 Files

    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.

Posting Permissions

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