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.

OMG, it works great. Thank you so much for resolving my dilemma. The only thing now was to remove the mentor's name next to their own name. So I added an if statement to your formula as follows and it worked great. Thank you, I greatly appreciate your help.
=IF(D2="Mentor","",IF(COUNT(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8),""),""))=1,INDEX($C$2:$C$8&", "&$B$2:$B$8,SMALL(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1)),INDEX($C$2:$C$8&", "&$B$2:$B$8,SMALL(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1))&" and "&INDEX($C$2:$C$8&", "&$B$2:$B$8,LARGE(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1))))

OMG, it works great. Thank you so much for resolving my dilemma. The only thing now was to remove the mentor's name next to their own name. So I added an if statement to your formula as follows and it worked great. Thank you, I greatly appreciate your help.
=IF(D2="Mentor","",IF(COUNT(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8),""),""))=1,INDEX($C$2:$C$8&", "&$B$2:$B$8,SMALL(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1)),INDEX($C$2:$C$8&", "&$B$2:$B$8,SMALL(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1))&" and "&INDEX($C$2:$C$8&", "&$B$2:$B$8,LARGE(IF($A$2:$A$8=A2,IF($D$2:$D$8="Mentor",ROW($D$2:$D$8)-1,""),""),1))))

Oop, I did a newbie mistake, posted twice. Just as a final entry after testing it on my big document I encountered some issue which I was able to resolve. I posted a small file for information and testing purposes, however, my file had 1000 rows, so I had to adjust it to accomodate the large number of rows making it more dynamic. Here is the result of my modifications for any user wishing to use this formula.
{=IF(D2="Mentor","",IF(COUNT(IF($A$2:$A$1000=A2,IF($D$2:$D$1000="Mentor",ROW($D$2:$D2),""),""))=1,INDEX($B$2:$B$1000&", "&$C$2:$C$1000,SMALL(IF($A$2:$A$1000=A2,IF($D$2:$D$1000="Mentor",ROW($D$2:$D2)-1,""),""),1)),INDEX($B$2:$B$1000&", "&$C$2:$C$1000,SMALL(IF($A$2:$A$1000=A2,IF($D$2:$D$1000="Mentor",ROW($D$2:$D2)-1,""),""),1))&" and "&INDEX($B$2:$B$1000&", "&$C$2:$C$1000,LARGE(IF($A$2:$A$1000=A2,IF($D$2:$D$1000="Mentor",ROW($D$2:$D2)-1,""),""),1))))} Thanks again p24leclerc for the formula, amazing work.