Results 1 to 3 of 3

INDEX & MATCH duplicate entry

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2019
    Location
    australia
    MS-Off Ver
    7
    Posts
    2

    Exclamation INDEX & MATCH duplicate entry

    Hi all,
    I have a master Data sheet with a lot of information and what I need to do on monthly basis is to validate this data and cross reference it against what has been submitted by the 3rd party.
    I have made a formula that searches, matches and returns the Data if its correct (refer to the attached excel file, column O and P) .

    There is a catch though... some of the data have duplicate reference numbers (for example same docket numbers) and when i run the formula its unable to distinguish whether if its a double up and ultimately the formula reference the incorrect details.

    Would you be able to assist me with a way to get around this?

    Please note that I cannot modify and rename the docket names with the same reference numbers.

    Many Thanks

    ScreenShot00086.jpg
    Attached Files Attached Files
    Last edited by Alx19; 07-01-2019 at 01:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index and Match duplicate results - How to show duplicate names?
    By barman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2018, 11:28 AM
  2. [SOLVED] Excel faster index/match formula entry
    By scotty1968 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-13-2018, 11:38 PM
  3. index-match with dynamic 'sheet' entry
    By nielsb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2018, 10:09 AM
  4. [SOLVED] Listing ALL entries of index/match (not just first entry)
    By Peelah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2017, 04:20 PM
  5. [SOLVED] Sum Duplicate Index-match-match Values
    By djh30 in forum Excel General
    Replies: 3
    Last Post: 01-06-2015, 11:27 PM
  6. Index Match most recent entry
    By aronhubbard in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2012, 07:02 PM
  7. Index Match IF Duplicate
    By england79m in forum Excel General
    Replies: 4
    Last Post: 03-29-2008, 10:46 AM

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