Closed Thread
Results 1 to 2 of 2

Index Match Function To Pull Multiple Rows Informations without Duplicates

  1. #1
    Registered User
    Join Date
    11-15-2016
    Location
    Colorado, United States
    MS-Off Ver
    MS 2013
    Posts
    9

    Index Match Function To Pull Multiple Rows Informations without Duplicates

    So I have an issue I've been trying to resolve on a spreadsheet I created. I'm using the index/match/iferror function in order to populate information on a separate tab in my workbook. The formula I'm using is pulling the pertinent information, however, when it comes across a field name that is duplicated - it uses the first entry in the selection rather than all entries, which all the consistently named rows is needed to populate this portion of the spreadsheet. In addition, I would need this function to filter duplicate entries. So on my attachments, I have two screen caps. on the export tab and one from the accounts tab. The accounts tab shows columns AG-AJ, which are the client fields used to populate the information in the export tab under client name. Column AL on the accounts tab shows where information from column A in the export tab gets populated to consolidate fee schedules. If the fee schedule is the same as another household, it will get populated underneath a singular row rather than multiple on the exports tab. This is the basis for the index/match/iferror function, which looks up the fields in column A of the export tab and based on matching values on the accounts tab, pulls the pertinent client information. So the problem is it will not pull the multiple clients information if under different rows. It seems the function goes to the first instance of the value found and solely uses that information rather than all matching entries. After that is done, I need the function to not populate duplicate entries. Any help would be appreciated! Thank you very much!





    Updated: This is the sample workbook. The columns changed a bit, so the columns we are working on in the export tab starts with column I, and continues with the columns highlighted in yellow. Again as a reminder we are trying to populate the client information from the accounts tab that follow under the same pricing tier without duplicating entries. Thank you very much!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,862

    Re: Index Match Function To Pull Multiple Rows Informations without Duplicates

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 12-01-2016, 12:18 PM
  2. Pull rev letters from index(match), multiple rows of same DWG# each diff rev
    By Cwyso1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2014, 03:03 PM
  3. [SOLVED] Problem Using LARGE formula with Index/Match to pull values when there are Duplicates
    By BDavis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-11-2014, 02:23 PM
  4. Index and Match function across multiple rows with repeating names
    By FKOC in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-09-2014, 11:17 PM
  5. Index match function without array formula for multiple rows.
    By markb141 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2014, 10:35 AM

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