+ Reply to Thread
Results 1 to 7 of 7

Matching and Indexing

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    8

    Matching and Indexing

    Hello,

    I'm have a table tracking relationships between Mentors and Mentees (see the attached table). I would like to input a mentee name in cell F2 and return everyone mentoring that person in the following column (G2 downward).

    Any thoughts? I suspect it is a complicated series of matching and indexing.
    Attached Files Attached Files

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Matching and Indexing

    vfaulkner,

    Attached is a modified version of your posted workbook. In cell G2 and copied down is this formula:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    05-31-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Matching and Indexing

    Thank you! This is exactly what i was looking for.

    Vfaulkner

  4. #4
    Registered User
    Join Date
    05-31-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Matching and Indexing

    tigeravatar,

    Do you know what the formula would be if I wanted to do the reverse lookup? IE look up the Mentee by Mentor?

  5. #5
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Matching and Indexing

    Where F2 is the name of the Mentor whose Mentees you're looking up:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-31-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Matching and Indexing

    Thanks again!

  7. #7
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Matching and Indexing

    You're very welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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