I'm hoping someone would help replace array formulas with VBA.
Report 1 is a list of folks who've completed certain trainings.
Report 2 is a list of everyone and all of their assigned trainings
What I need is for Report 2 to display the Signoff date and instructor next to the completed trainings.
Report 2 displays exactly how I need it to but I am having to use array formulas in columns E & F to achieve it.
In the actual document, these array formulas number in the thousands which really slow down the WB especially since it's updated whenever a training is added and when completed.
I'm hoping someone would be willing to replace the Array formulas with VBA.
Also, maybe this can be accomplished in Power Query.
Either way, the array formulas work, but they make the program almost unusable.
The below pics come from the attached example (which is xlsm but with no scripts).
Thanks for any help with this
Training SignOff List
Report 2 (Thanks Mumps)