Results 1 to 3 of 3

Index and Match has duplicate results

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Index and Match has duplicate results

    Hi, new to this:

    I have been battling with trying to extract data from a range of data and I am getting duplicate results:

    See attached, in E2 I am putting in the name "Bob", with a formula =IFERROR(INDEX(B2:B11,MATCH($E$2,$A2:$A11,0)),"")
    the result in G2,H2 and I2 have come from the first column with Bob or B5,C5 and D5
    The next 3 rows come back with duplicate data, then when it gets to G6, H6, and I6 I am getting the rest of the data I am looking for
    My question is" how do I stop it from duplicating, and only give me the 4 set of results I am looking for?, i.e B,C,D 4 to 8

    Thank for the help
    Jonathan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Not getting expected results from index match match
    By number1mm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2013, 03:56 PM
  2. Index/Match with multiple results
    By amcghee1 in forum Excel General
    Replies: 4
    Last Post: 10-18-2012, 12:15 PM
  3. [SOLVED] Using Index & Match always results in #N/A
    By ioswoody in forum Excel General
    Replies: 3
    Last Post: 07-05-2012, 01:52 AM
  4. INDEX & MATCH fuctions w/data that could have duplicate results
    By SociableMonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2012, 05:52 PM
  5. 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