Oh how I hate excel formulas, so much so that I’m posting this one hoping that someone can reuse it one day…
=IF(RC[-1]=”HP”,”Head of Production”,IF(RC[-1]=”EP”,”Executive Producer”,IF(RC[-1]=”HC”,”Head of Content”,IF(RC[-1]=”PC”,”Production Coordinator”,IF(RC[-1]=”BPM”,”Business Manager”,IF(RC[-1]=”HR”,”Recruitment”,IF(RC[-1]=”HIP”,”Head of Intergrated Production”,IF(RC[-1]=”“, “”,IF(RC[-1]=”CD”,”Creative Director”)))))))))
It looks for a value and replaces a successfull match with the full name.
