+ Reply to Thread
Results 1 to 1 of 1

Second and Third Match on Index Needed

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Second and Third Match on Index Needed

    I was assisted to achieve the following index lookup based on the attached document. It turns out I actually need to be able to achieve any other matches as well, as their are several many-to-many relationships in my file.

    Here's what I've got thus far, to get the first/primary match: =IFERROR(INDEX('Alix IDs'!$A$2:$A$7,MATCH("*"&$A2&"*",'Alix IDs'!$B$2:$B$5,0)),INDEX('Alix IDs'!$A$2:$A$7,MATCH($A2,'Alix IDs'!$B$2:$B$5,0)))

    I need to know how to get the index lookup to include all matches of a respective ID, in one final cell.
    So if I want the equation to show me all the AlixIDs associated with the FeatureID, from another tab, and there are 3 names in the other tab for that ID (in different rows), how do I get them to populate in one cell, one after the next, in my master lookup tab?
    For each ID, there can be many names, and for each name, there can be many IDs. it's a many to many relationship.

    Please see the attachment to understand better.

    Attached Files Attached Files

+ 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: 2
    Last Post: 09-27-2014, 04:34 PM
  2. Sum Index Match help needed
    By vhache in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 09:01 AM
  3. Index match help needed
    By jmanz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-06-2012, 05:52 AM
  4. Help needed with INDEX MATCH...
    By Nerf Herder in forum Excel General
    Replies: 4
    Last Post: 06-27-2012, 04:40 AM
  5. Index and Match Help Needed
    By carl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2005, 05:05 PM


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