Mark as Correct/Wrong when cell equals...?

[Bee008]

Hello : )

I am stuck on creating a formula and would really appreciate any help. I have uploaded spreadsheets to help explain what I'm looking to do.

In spreadsheet P5, Column P represents a recognition test, whereby you are either correct or incorrect. The responses given are in column S (for each of the 54 recognition tests). P5.xlsx

The correct responses are in spreadsheet 'Multiple Choice Answers'. MultipleChoiceAnswers.xlsx

I need column P to say either 'Correct' or 'Wrong' dependent on the responses that are in column S.
So, for example, for the first one (P2) it needs to input 'Correct' if S2 = mc3, and 'Wrong' if S2 equals anything else (mc1, mc2, mc4). With a formula that is easily copied into 59 other worksheets.


Thank you, Bee

[SAFC]

Please Login or Register  to view this content.

I would suggest having the MultipleChoiceAnswers inside the P5 workbook. If you did that, it would be

Please Login or Register  to view this content.

[Bee008]

Please Login or Register  to view this content.

I would suggest having the MultipleChoiceAnswers inside the P5 workbook. If you did that, it would be

Please Login or Register  to view this content.

Wonderful! Thank you very much indeed