We only need three formulas, if I'm not mistaken.
In order to fill the first 2 columns in trainee scheduling:
Formula:
=FILTER(FILTER(Info!$A$3:$C$17,Info!$C$3:$C$17=LEFT(Schedule!E10,4),""),{1,1,0})
(not sure formula translator is up to the task with arrays, but it should work on the file)
For the remaining columns
Formula:
=TRANSPOSE(INDEX(Info!$F$3:$N$12,,MATCH(Schedule!F11,Info!$F$2:$N$2,0)))
And finally, for the presenter scheduling
Formula:
=INDEX(Info!$F$17:$H$26,MATCH(G$28,Info!$E$17:$E$26,0),MATCH($F29,Info!$F$16:$H$16,0))
HTH,
Francesco
Bookmarks