Forum Discussion
School Presentation Day Data: Help save me endless hours of typing
I recently started working in a school and I'm finding our processes are a little dated. Presentation day prep for end of year is so huge and I spent days typing everything out last year, we need a b...
As variant that could be combined
by
=TEXTJOIN(CHAR(10),,IF(INDEX($D$3:$O$5,MATCH(B8,$B$3:$B$5),0)="","",$D$2:$O$2))