Nested IF Function problem, involving index/match

[nonymous]

(Please see the attachment)
Module.xlsx

So Basically,

Sheet one is Data on how some students attempted a question
Module is the correct answer and marks for each question

What i have to do in sheet 2 is give marks to each student using the other two tables. If the answer given for a question is right then the marks given in the module sheet should be awarded.. if not simply 0.

Help?
Many thanks.

[Olly]

You're very nearly there - just need some absolute / relative references sorted out. So, in Sheet2!B3, enter:

Please Login or Register  to view this content.

Then copy this to Sheet2!B3:F7

[ConneXionLost]

In cell Module!C3, use:

Please Login or Register  to view this content.

Copy/autofill down.

In cell Sheet2!B3, use:

Please Login or Register  to view this content.

Copy autofill across and down.

[nonymous]

You're very nearly there - just need some absolute / relative references sorted out. So, in Sheet2!B3, enter:

Please Login or Register  to view this content.

Then copy this to Sheet2!B3:F7

You are an absolute star! Much appreciated olly!

Edit: Also thanks to ConneXion for you're answer as well.