Results 1 to 6 of 6

index, match, concatenate issue

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2015
    Location
    Ottawa
    MS-Off Ver
    7
    Posts
    4

    index, match, concatenate issue

    Hi,
    I have groups of Students and Mentors and using index match I have been able to isolate the names of the mentors next to the students by group. In some instances, their may be two mentors in a group but I am unable to concatenate the two mentor's first and last names. Here is the formula I am currently using to acquire the mentor's name next to the students in the appropriate group. {=IF(D3="Mentor","",INDEX($B$2:$B$8&", "&$C$2:$C$8,MATCH(A3,IF($D$2:$D$8="Mentor",$A$2:$A$8),0)))} As you can see on the attached Excel worksheet(Mentor Test), it only picks up the first mentor not the second mentor. What I would like to see is the two mentors within the same group show up next to the students within that group (See Mentor Results as an example of what I would like to see). Can any of you GURUS help me in my dilemma.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match Index and Concatenate Formula
    By kharding15 in forum Excel General
    Replies: 4
    Last Post: 10-02-2015, 09:01 PM
  2. Match Index, Small Index with Concatenate
    By kharding15 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2015, 05:38 PM
  3. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  4. Help Using Concatenate with Index Match
    By billyshears in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-25-2013, 10:09 AM
  5. [SOLVED] Index, Match and Concatenate
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2012, 09:55 PM
  6. [SOLVED] INDEX-MATCH w/ CONCATENATE
    By zamgold in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2012, 11:08 AM
  7. [SOLVED] Index/Match or sumproduct with concatenate
    By pauldaddyadams in forum Excel General
    Replies: 14
    Last Post: 04-18-2012, 12:30 AM

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