Collating Information to Map Users to Training Courses

Hello,

I have a document with 2 tabs:

1 tab has 120 columns containing business roles and rows of users assigned to these business roles
1 tab has 69 columns containing training courses and rows of MULTIPLE business roles assigned to these training courses

I now need to collate this information to map users to training courses using the user to business role information on the first tab.

Does anybody know the best approach to do this?? I was thinking multiple Vlookups but it is proving difficult!

Thanks in advance