Pretty straightforward really
=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)),""))
Don't forget the spaces.
Bookmarks