I have so far all the names of teachers who match students post code, subject and age phase using TEXTJOIN.
I have then used TEXTSPLIT to separate the teachers names into columns.
Under the PostCode I have allowed up to 10 columns for names to be split into and the same for subject match so 30 columns in total, each cell holds the teachers name.
I want to dynamically search each array for the names of teachers that appear in all arrays, there could be more than 1 or there may be none, they may just sit in one array or two arrays as opposed to three.