+ Reply to Thread
Results 1 to 2 of 2

Vlookup to find missing or replicated data`

  1. #1
    Registered User
    Join Date
    10-16-2007
    Posts
    8

    Vlookup to find missing or replicated data`

    I have read all threads I could find but don't seem to have the same needs.

    I have two worksheets they both have same and different data.
    I need to bring "ACE Report" into Master 1 customs. If I just copy/paste, I will have replicated (duplicate) or transposed info which I don't want. Each row has to be unique. It will then be exported to Access.

    If I run a Vlookup in Master 1 to find the replicated data in ACE Report, my result should be:

    "N/A"
    "N/A"
    "N/A"
    "N/A" and
    110-3758795-9
    112-1234567-8
    "N/A"
    etc. But, I get the N/A and some of the entries appear but the are repeated a certain number of time and then another number apprears and it goes on and on. What is wrong in my formula or is it the wrong formula? I have tried performing the Vlookup in the worksheet "ACE report". I have tried the Match, Hlookup, Lookup, unsuccessfully.
    I'm baffled!!

    Any kind of help will be greatly appreciated.
    Attached Files Attached Files
    Last edited by excelhlp; 01-12-2008 at 09:55 PM. Reason: Still no answer - tried every possible way to understand other Vlookup problems

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    before you go any further there are duplicate entries on ace reports in column A eg rows 55/56 row 57/58 perhaps you might like to sort that bit out first!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1