Dear gebobs

Thank you for your reply. To answer your first question, this is how the participants enter it. I don't know whether you are a betting man / woman but this is a university system so the odds of getting anything changed are zero.

As for the rest of your reply, yes this is how they enter it and they only have one report each. Therefore, I will give this combination of an MID function and VLOOKUP definitely a go.