Best way to cross populate multiple arrays based on data entry into a single array?

[mrmmickle1]

Orestees,

If you have people editing the bottom array in the sheet you may want to lock all of the top cells with these formulas in them....
typically people will mess things up if you give them an opportunity. This way you can prevent having to go in and fix these formulas later.

[Orestees]

Very true, lol. Thanks for the heads up!

[Orestees]

User requested an adjustment. Is there a method to use this formula to return results for multiple names? If a trainee is sitting with multiple trainers, right now, the formula only returns the first occurence it finds rather than mutiple occurances. Hopefully I'm making sense, just flustered by the request and deciding I might be bright enough to give it a run. . . to no avail.

Thanks in advance for taking a look!

[snb]

Please do not use merged cells.
Structuring precedes coding.

[Orestees]

Thanks for taking a look snb, unfortunately, the user won't be able to have multiple cells with the instructors or trainees name within the b column. Visually, they're requesting that it stays identical to the uploaded sample. Would there be a way to work this formula into something with this type of flexibility?

Thanks again in advance!