Required Excel VBA,Google Docs,Microsoft Excel freelancer for Google Sheets - Custom script/macro to grade answers job

We have a multichoice quiz with 8 options:
A) BCC
B) Dermatofibroma
C) Solar lentigo/Seb K
D) Vascular lesion
E) Melanoma
F) Nevus
G) SCC in situ or invasive
H) Other Benign
We have a quiz app that automatically grades which answer is correct from student responses.

However, we would like to do secondary analysis of the results. So that, for example, B, C, D, F, H = Correct and A, E, G is Incorrect. Can you make a formula / script that makes this fast and easy to do?

Answer key should be on another google sheet

I can use array formula but would be good to have an easier way to solve this without creating multiple columns (30).

Skills & Expertise Required

Excel VBA Google Docs Microsoft Excel