Comparing arrays from 2 sheets and returning values that match the pattern (VBA?)

[NotExcelSavvy]

I am attempting to build a workbook in which the user can enter information about learner enrolment in courses and this gets mapped to the various qualifications the learner can achieve
I have the following information
List of learners with the courses they are enrolled in (a row for each course a learner is enrolled in)
List of qualifications with the courses required to achieve each one

The courses can be mapped to qualifications as follows:

• 1 course mapped to 1 qualification (Learner X is enrolled in Course 1, they will achieve Qual 1)
• 1 course mapped to multiple qualifications (Learner Y is enrolled in Course 2, they will achieve Qual 2 and Qual 3)
• Multiple courses map to 1 qualification (Learner Z is enrolled in Course 1, 2 and 3, they will achieve Qual 4)

I first consolidated the courses the learners are enrolled in so each learner has one row, the various courses are represented by columns, each enrolled course is shown by X. (imgs attached: Learners Database > Learners Information). Similarly I set up the Qualification Mapping (img attached) with the same columns (courses) and courses required for each qual are shown by X (not sure if this is the best way, open to other suggestions).

I want to be able to compare all the courses the learner has completed with the courses that are required for each qualification, to see which ones they are eligible for (result shown in yellow cells in Learners Information image). I'm not sure how to achieve that though.

I'm assuming a comparison of this sort would be done through VBA? If so could anyone please suggest what the code would look like?

Is there a better way to set up this workbook?

Notes:
There are 150 qualifications achieved through various combinations of 150 courses
There will be a large database of learners (1000+)

Really appreciate any help!!