Results 1 to 18 of 18

Index Match Function To Pull Multiple Consistent Rows of Information Rather Than 1st One

Threaded View

  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 Consistent Rows of Information Rather Than 1st One

    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!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. trying use index match to pull information from database to individual sheet
    By garvey1973 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2015, 07:33 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. 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
  4. Replies: 8
    Last Post: 07-09-2012, 02:38 PM
  5. Replies: 8
    Last Post: 03-22-2012, 03:02 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