Try this maybe..tweaked version of Post # 15

=TRIM(IFERROR(C140&INDEX(C140:C$329,MATCH("~**",IF(C140:C$329<>"* SR Maintenance accounts only",IF(C140:C$329<>"* SR Contracted Out Services",C140:C$329),IF(C140:C$329<>"* P & M Other Overhead Costs","")),0)),""))