Need Index and Match to return multiples values in the same cell

[ludi]

Hi, I'm working on a RACI chart, I need to attribute Tasks to team members. As the RACI is quite large and complex, I want to recap by tasks who's is responsible , accountable....
So I used a Index/match formula, but as I may have many person as accountable or support, I need to return multiples values in the same cell.

No clue how to do that ... Anyone??

(for security issue I can't upload my file)

[NBVC]

You would need a UDF...

see here for a sample that you can try to adapt to your workbook.

http://www.excelforum.com/excel-gene...ml#post2722784

[ludi]

Nice Thanks a lot!

I also try this:
As VBA:

Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)
Dim r As Range
Dim result As String
result = ""
For Each r In lookuprange
If r = lookupval Then
result = result & " " & r.Offset(0, indexcol - 1)
End If
Next r
MYVLOOKUP = result
End Function


Then as formula: =MYVLOOKUP(A1,A1:A20,2)

Both works!
thanks again!