can I do this???
=IF(FIND(B5,C21),B21 & ", ","") & IF(FIND(B5,C22),B22 & ", ","") &
IF(FIND(B5,C23),B23 & ", ","") & IF(FIND(B5,C24),B24 & ", ","") &
IF(FIND(B5,C25),B25 & ", ","") & IF(FIND(B5,C26),B26 & ", ","") &
IF(FIND(B5,C27),B27 & ", ","") & IF(FIND(B5,C28),B28 & ", ","") &
IF(FIND(B5,C29),B29 & ", ","") & IF(FIND(B5,C30),B30 & ", ","") &
IF(FIND(B5,C31),B31 & ", ","") & IF(FIND(B5,C32),B32 & ", ","") &
IF(FIND(B5,C33),B33 & ", ","") & IF(FIND(B5,C34),B34 & ", ","") &
IF(FIND(B5,C35),B35 & ", ","") & IF(FIND(B5,C36),B36 & ", ","") &
IF(FIND(B5,C37),B37 & ", ","") & IF(FIND(B5,C38),B38 & ", ","") &
IF(FIND(B5,C39),B39 & ", ","") & IF(FIND(B5,C40),B40 & ", ","") &
IF(FIND(B5,C41),B41 & ", ","") & IF(FIND(B5,C42),B42 & ", ","") &
IF(FIND(B5,C43),B43 & ", ","") & IF(FIND(B5,C44),B44 & ", ","")

What I want to accomplish is creating a list of groups that any one person
belongs to. Spreadsheet looks like this

b5 = 'chuck'
b6 = 'terry'
b7 = 'mike'
b8 = 'kathy'

b21 = 'groupname1'
c21 = 'chuck, terry, mike, kathy'

b22 = 'groupname2'
c22 = 'chuck, mike, kathy'

b23 = 'groupname3'
c23 = 'mike, terry, kathy'

I would like to use a formula in the cells corresponding to the person -
cells c5, c6, and c7 should show
c5 = 'groupname1, groupname2'
c6 = 'groupname1, groupname3'
c7 = 'groupname1, groupname2'
c8 = 'groupname1, groupname2, groupname3'

I got an error in the formula above. Once it is perfected I could put a
left(formula,len(c5)-2) to remove the extra ", ", but I can't seem to be
able to get that function to work. Does anyone have a suggestion?