+ Reply to Thread
Results 1 to 2 of 2

Index > Match Function Producing Several Duplicates

  1. #1
    Registered User
    Join Date
    08-01-2019
    Location
    Wisconsin, USA
    MS-Off Ver
    2016
    Posts
    1

    Unhappy Index > Match Function Producing Several Duplicates

    I am using the Index> Match Function to show items on a new sheet on the basis of "Y" being entered into an adjacent column (images attached). My problem is that, if there are spaces or "N" rather than "Y" in that column, my new page produced the same number of duplicate values as the spaces in between. For example, N323 in the Master Sheet is checked "Y", but there are 5 rows above it that have values other than "Y"; therefore, there are 6 total copies of the corresponding "PB 7'-11'" value in the next sheet.
    My formula is (example using cell A322): =INDEX(MASTER!A324:N1084,MATCH("Y",MASTER!N324:N1084,0),1)
    Does anyone know how to fix this?
    Reference Page.PNG
    Output Page.PNG
    Last edited by loveday; 08-01-2019 at 11:06 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,082

    Re: Index > Match Function Producing Several Duplicates

    Hello loveday and Welcome to Excel Forum.
    It is hard to trouble shoot a formula based on screen shots and would be easier to help if you could upload the file from which the screen shots are taken.
    Note that it will also help to see a manually produced version of the "new sheet" so that we will know what our proposed formulas/code are supposed to yield.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-02-2018, 12:10 AM
  2. [SOLVED] Accounting for duplicates with LARGE function (within index match)
    By quart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2017, 10:38 AM
  3. Index Match Function To Pull Multiple Rows Informations without Duplicates
    By adamdeeakaaj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2016, 03:41 PM
  4. [SOLVED] tie scores (stopping/skipping duplicates) using index/match plus small function
    By Mrjpjones in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2016, 02:13 PM
  5. [SOLVED] Alternatives to "INDEX(MATCH(" Function when Duplicates Exist
    By MidwestBen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-02-2013, 09:14 PM
  6. [SOLVED] Index and Match combination producing the wrong result
    By Authentik8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2012, 11:01 AM
  7. Replies: 2
    Last Post: 03-16-2012, 12:03 PM

Tags for this Thread

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